The highest tagged major version is v2.

excelKit

package

v1.3.13 Latest Latest Go to latest Published: Mar 28, 2023 License: Apache-2.0 Imports: 6 Imported by: 0

Details

View Source

const (
	// MaxRow row的取值范围: [0, 1048575]
	MaxRow = 1048575
	// MaxCol col的取值范围: [0, 16383]
	MaxCol = 16383
)

This section is empty.

func ConvertAxisToRowCol(axis string) (int, int, error)

ConvertAxisToRowCol

e.g. ("C2") =>

func ConvertColToString(col int) (string, error)

ConvertColToString

e.g. (0) => "A", nil (16368) => "XEO", nil

func ConvertRowColToAxis(row, col int) (string, error)

ConvertRowColToAxis

e.g. (1, 2) => "C2", nil

func ConvertRowToString(row int) (string, error)

func NewEmptyFile(path string, opts ...excelize.Options) (*excelize.File, error)

NewEmptyFile 新建1个空白的Excel文件（其内只有1个空白的工作表，表名为"Sheet1"）

@param path 文件的路径（如果文件已经存在，会覆盖它）

This section is empty.