Documentation
¶
Index ¶
Constants ¶
This section is empty.
Variables ¶
This section is empty.
Functions ¶
func AxisToIndex ¶
AxisToIndex converts excel coordinates to to generical indexes
func ColumnToIndex ¶
ColumnToIndex converts an excel column name to his index, if the name contains special chars or numbers returns -1
func IndexToAxis ¶
IndexToAxis converts 2 int coordinates to excel coordinates
func IndexToColumn ¶
IndexToColumn converts an index (starting at 0) to a excel column: 0 -> A 1 -> B 26 -> AA 27 -> AB 52 -> BA if the index is negative returns empty
func IndexToRow ¶
IndexToRow converts the generical Index numeration to excel numeration - generical numeration starts at 0 - excel numeration starts at 1
func OpenOrCreateSheet ¶
OpenOrCreateSheet checks if the excel sheet exists if exists set it as active otherways it creates it and then set it as active
func RowIndexToAxis ¶
RowIndexToAxis converts a row index and a column (already given with excel coordinates)
func RowToIndex ¶
IndexToRow converts the excel numeration to generical Index numeration - generical numeration starts at 0 - excel numeration starts at 1
Types ¶
This section is empty.