Documentation ¶
Index ¶
- func GetCellIndex(row, col int) string
- func GetColIndex(num int) string
- func GetSheetList(excelFile *excelize.File) []string
- func GetSheetNameByIndex(file *excelize.File, index int) string
- func ReWriteSheet(file *excelize.File, sheetName string)
- func RemoveSheet(file *excelize.File, sheetName string)
- func RowsToJson(rows []*Row) []map[string]string
- func RowsToJsonByKey(rows []*Row, keys ...string) map[string]map[string]string
- func Save(file *excelize.File)
- func SaveAs(file *excelize.File, filename string)
- type Cell
- func (cell *Cell) GetFloatValue() float64
- func (cell *Cell) GetIndent() int
- func (cell *Cell) GetStyle() *excelize.Style
- func (cell *Cell) GetType() string
- func (cell *Cell) SaveStyle()
- func (cell *Cell) SetCellBoolValue(val bool)
- func (cell *Cell) SetCellIntValue(val int)
- func (cell *Cell) SetCellStrValue(val string)
- func (cell *Cell) SetCellValue(val any)
- func (cell *Cell) SetComment(title, comment string)
- func (cell *Cell) SetFillErrorStyle()
- func (cell *Cell) SetFillStyle(color string)
- func (cell *Cell) SetFillWarnStyle()
- func (cell *Cell) SetFontErrorStyle()
- func (cell *Cell) SetFontStyle(color string)
- func (cell *Cell) SetFontWarnStyle()
- func (cell *Cell) SetIndent(indent int)
- type Row
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func GetSheetNameByIndex ¶
根据索引获取工作表
func RowsToJson ¶
func RowsToJsonByKey ¶
Types ¶
type Cell ¶
type Cell struct { File *excelize.File SheetName string Value string RowIndex int ColIndex int Position string // contains filtered or unexported fields }
单元格
func (*Cell) SetCellBoolValue ¶ added in v0.0.4
func (*Cell) SetCellIntValue ¶ added in v0.0.4
func (*Cell) SetCellStrValue ¶ added in v0.0.4
func (*Cell) SetCellValue ¶ added in v0.0.4
func (*Cell) SetComment ¶
func (*Cell) SetFillErrorStyle ¶
func (cell *Cell) SetFillErrorStyle()
func (*Cell) SetFillStyle ¶
func (*Cell) SetFontErrorStyle ¶
func (cell *Cell) SetFontErrorStyle()
func (*Cell) SetFontStyle ¶
Click to show internal directories.
Click to hide internal directories.