excel

func LetterAxis ¶

func LetterAxis(index int) string

LetterAxis generate the corresponding column letter position.

NOTE: index is 0-based.

func Open ¶ added in v0.9.7

func Open(filename string, sheetName string) (*excelize.File, error)

Open opens a new excel file. If the file already exists, it will be removed firstly.

func Position ¶ added in v0.15.0

func Position(row, col int) string

Position generate the position (row, col) (e.g.: A1) in a sheet.

NOTE: row and col are both 0-based.