office

Documentation

Index

• func MakeCellID(col, row int) string
• func MakeColID(col int) string
• func ParseCellID(cell string) (col, row int)
• type Excel
  • func OpenExcel(filename string, password *string) (*Excel, error)
  • func (xls *Excel) Get(sheetName string, start, end *string) ([][]any, error)
  • func (xls *Excel) GetData(sheetName string, start, end *string) ([]map[string]any, error)
  • func (xls *Excel) GetSheetName(sheetName string) string
  • func (xls *Excel) MakeStyle(style excelize.Style) (int, error)
  • func (xls *Excel) RemoveSheet(sheetName string) error
  • func (xls *Excel) Save(filename, password *string) error
  • func (xls *Excel) Set(sheetName string, table [][]any, start, end *string) error
  • func (xls *Excel) SetAutoFilter(sheetName string, start, end string, option *[]excelize.AutoFilterOptions) error
  • func (xls *Excel) SetCellStyle(sheetName string, start string, end string, styleID int) error
  • func (xls *Excel) SetColWidth(sheetName string, startCol string, endCol string, width float64) error
  • func (xls *Excel) SetColWidths(sheetName string, widths []float64) error
  • func (xls *Excel) SetData(sheetName string, data []map[string]any, start, end *string) error
  • func (xls *Excel) SetPanes(sheetName string, panes excelize.Panes) error
  • func (xls *Excel) Sheets() []string
  • func (xls *Excel) WriteToBuffer() ([]byte, error)

Functions

func MakeCellID

func MakeCellID(col, row int) string

func MakeColID

func MakeColID(col int) string

func ParseCellID

func ParseCellID(cell string) (col, row int)

Types

type Excel

type Excel struct {
	// contains filtered or unexported fields
}

func OpenExcel

func OpenExcel(filename string, password *string) (*Excel, error)

func (*Excel) Get

func (xls *Excel) Get(sheetName string, start, end *string) ([][]any, error)

func (*Excel) GetData

func (xls *Excel) GetData(sheetName string, start, end *string) ([]map[string]any, error)

func (*Excel) GetSheetName

func (xls *Excel) GetSheetName(sheetName string) string

func (*Excel) MakeStyle

func (xls *Excel) MakeStyle(style excelize.Style) (int, error)

func (*Excel) RemoveSheet

func (xls *Excel) RemoveSheet(sheetName string) error

func (*Excel) Save

func (xls *Excel) Save(filename, password *string) error

func (*Excel) Set

func (xls *Excel) Set(sheetName string, table [][]any, start, end *string) error

func (*Excel) SetAutoFilter

func (xls *Excel) SetAutoFilter(sheetName string, start, end string, option *[]excelize.AutoFilterOptions) error

func (*Excel) SetCellStyle

func (xls *Excel) SetCellStyle(sheetName string, start string, end string, styleID int) error

func (*Excel) SetColWidth

func (xls *Excel) SetColWidth(sheetName string, startCol string, endCol string, width float64) error

func (*Excel) SetColWidths

func (xls *Excel) SetColWidths(sheetName string, widths []float64) error

func (*Excel) SetData

func (xls *Excel) SetData(sheetName string, data []map[string]any, start, end *string) error

func (*Excel) SetPanes

func (xls *Excel) SetPanes(sheetName string, panes excelize.Panes) error

func (*Excel) Sheets

func (xls *Excel) Sheets() []string

func (*Excel) WriteToBuffer

func (xls *Excel) WriteToBuffer() ([]byte, error)