excel

Documentation

Index

• func ToChar(i int) rune
• type ExcelColumn
  • func (ec ExcelColumn) Int() int
• type ExcelFile
  • func NewFile(opts ...excelize.Options) *ExcelFile
  • func (e *ExcelFile) MergeCellColumn(mergeCell map[string]string) *ExcelFile
  • func (e *ExcelFile) NewSheet(sheetName string) (index int, err error)
  • func (e *ExcelFile) NextColumnValue()
  • func (e *ExcelFile) NextRowValue()
  • func (e *ExcelFile) SetHeader(startColumn int, startRow int, headersName ...string) *ExcelFile
  • func (e *ExcelFile) SetValues(startColumn int, startRow int, data ...any) *ExcelFile
  • func (e *ExcelFile) WriteToByte() []byte

Functions

func ToChar

func ToChar(i int) rune

Types

type ExcelColumn

type ExcelColumn int

const (
	A ExcelColumn = iota + 1
	B
	C
	D
	E
	F
	G
	H
	I
	J
	K
	L
	M
	N
	O
	P
	Q
	R
	S
	T
	U
	V
	W
	X
	Y
	Z
)

func (ExcelColumn) Int

func (ec ExcelColumn) Int() int

type ExcelFile

type ExcelFile struct {
	F                 *excelize.File
	SheetName         string
	StartHeaderColumn int
	StartHeaderRow    int
	StartValueColumn  int
	StartValueRow     int
}

func NewFile

func NewFile(opts ...excelize.Options) *ExcelFile

func (*ExcelFile) MergeCellColumn

func (e *ExcelFile) MergeCellColumn(mergeCell map[string]string) *ExcelFile

func (*ExcelFile) NewSheet

func (e *ExcelFile) NewSheet(sheetName string) (index int, err error)

func (*ExcelFile) NextColumnValue

func (e *ExcelFile) NextColumnValue()

func (*ExcelFile) NextRowValue

func (e *ExcelFile) NextRowValue()

func (*ExcelFile) SetHeader

func (e *ExcelFile) SetHeader(startColumn int, startRow int, headersName ...string) *ExcelFile

startColumn represent where alphabet of column start e.g 1 = A; 2 = B; 3 = C; . . .; 26 = Z startRow represent where number of row start e.g 1; 2; 3; headersName represent of what you will given header name in excel

func (*ExcelFile) SetValues

func (e *ExcelFile) SetValues(startColumn int, startRow int, data ...any) *ExcelFile

startColumn represent where alphabet of column start e.g 1 = A; 2 = B; 3 = C; . . .; 26 = Z startRow represent where number of row start e.g 1; 2; 3; data represent of what data will fill in sheet

func (*ExcelFile) WriteToByte

func (e *ExcelFile) WriteToByte() []byte