sheet

Documentation

Index

• Constants
• func ColIndexToLetters(colIndex uint32) string
• func ColNumberToLetters(colNumber uint32) string
• func CoordinateNumbersToSheetLocation(colNum, rowNum uint32) string
• func CoordinatesToSheetLocation(colIdx, rowIdx uint32) string
• func SetRowValues(f *excelize.File, sheetName string, rowIndex uint, rowValues []interface{}) error

Constants

const (
	ExcelMaxColCount = 16384
	ExcelMaxRowCount = 1048576
	Alphabet         = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
	ZZ               = uint32(702)
	ZZIndex          = uint32(701)
)

Functions

func ColIndexToLetters

func ColIndexToLetters(colIndex uint32) string

func ColNumberToLetters

func ColNumberToLetters(colNumber uint32) string

func CoordinateNumbersToSheetLocation

func CoordinateNumbersToSheetLocation(colNum, rowNum uint32) string

CoordinateNumbersToSheetLocation converts x, y integer coordinates to a spreadsheet location such as "AA1" for col 27, row 1.

func CoordinatesToSheetLocation

func CoordinatesToSheetLocation(colIdx, rowIdx uint32) string

CoordinatesToSheetLocation converts x, y integer coordinates to a spreadsheet location such as "AA1" for col 27, row 1.

func SetRowValues

func SetRowValues(f *excelize.File, sheetName string, rowIndex uint, rowValues []interface{}) error