CoreExcel

Documentation

Index

• func AddCell(excel *excelize.File, sheetName string, column string)
• func AddRow(excel *excelize.File, sheetName string, row int)
• func GetCellValue(excel *excelize.File, sheetName string, axis string) string
• func GetSheetRows(excel *excelize.File, sheetName string) [][]string
• func LoadFile(src string) (*excelize.File, error)
• func NewFile() *excelize.File
• func SaveFile(excel *excelize.File, src string) error
• func SetCellString(excel *excelize.File, sheetName string, axis string, value string)

Functions

func AddCell

func AddCell(excel *excelize.File, sheetName string, column string)

AddCell 加入列

func AddRow

func AddRow(excel *excelize.File, sheetName string, row int)

AddRow 加入行

func GetCellValue

func GetCellValue(excel *excelize.File, sheetName string, axis string) string

GetCellValue 读取某列行内容

func GetSheetRows

func GetSheetRows(excel *excelize.File, sheetName string) [][]string

GetSheetRows 获取子表

func LoadFile

func LoadFile(src string) (*excelize.File, error)

LoadFile 打开一个新的文件

func NewFile

func NewFile() *excelize.File

NewFile 建立新文件

func SaveFile

func SaveFile(excel *excelize.File, src string) error

SaveFile 保存修改结果

func SetCellString

func SetCellString(excel *excelize.File, sheetName string, axis string, value string)

SetCellString 写入某列行内容