sheet

Documentation

Index

• Constants
• func ColIndexToLetters(colIndex uint) string
• func ColNumberToLetters(colNumber uint) string
• func CoordinateNumbersToSheetLocation(colNum, rowNum uint) string
• func CoordinatesToSheetLocation(colIdx, rowIdx uint) string

Constants

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

Functions

func ColIndexToLetters

func ColIndexToLetters(colIndex uint) string

func ColNumberToLetters

func ColNumberToLetters(colNumber uint) string

func CoordinateNumbersToSheetLocation

func CoordinateNumbersToSheetLocation(colNum, rowNum uint) 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 uint) string

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