excel

package
v0.1.0 Latest Latest
Warning

This package is not in the latest version of its module.

Go to latest
Published: Jan 24, 2024 License: GPL-3.0 Imports: 6 Imported by: 0

Documentation

Index

Constants

This section is empty.

Variables

This section is empty.

Functions

func AxisToIndex

func AxisToIndex(s string) (int, int)

AxisToIndex converts excel coordinates to to generical indexes

func ColumnToIndex

func ColumnToIndex(c string) int

ColumnToIndex converts an excel column name to his index, if the name contains special chars or numbers returns -1

func IndexToAxis

func IndexToAxis(x, y int) string

IndexToAxis converts 2 int coordinates to excel coordinates

func IndexToColumn

func IndexToColumn(i int) string

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

func IndexToRow(x int) int

IndexToRow converts the generical Index numeration to excel numeration - generical numeration starts at 0 - excel numeration starts at 1

func OpenOrCreateSheet

func OpenOrCreateSheet(xlsx *excelize.File, s string) int

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

func RowIndexToAxis(x string, y int) string

RowIndexToAxis converts a row index and a column (already given with excel coordinates)

func RowToIndex

func RowToIndex(x int) int

IndexToRow converts the excel numeration to generical Index numeration - generical numeration starts at 0 - excel numeration starts at 1

Types

This section is empty.

Jump to

Keyboard shortcuts

? : This menu
/ : Search site
f or F : Jump to
y or Y : Canonical URL