excelKit

Documentation

Index

• Constants
• Variables
• func ConvertAxisToRowCol(axis string) (int, int, error)
• func ConvertColToString(col int) (string, error)
• func ConvertRowColToAxis(row, col int) (string, error)
• func ConvertRowToString(row int) (string, error)
• func NewEmptyFile(path string, opts ...excelize.Options) (*excelize.File, error)

Constants

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

Variables

var NewFile func(opts ...excelize.Options) *excelize.File = excelize.NewFile

var OpenFile func(filename string, opts ...excelize.Options) (*excelize.File, error) = excelize.OpenFile

var OpenReader func(r io.Reader, opts ...excelize.Options) (*excelize.File, error) = excelize.OpenReader

Functions

func ConvertAxisToRowCol

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

ConvertAxisToRowCol

e.g. ("C2") =>

func ConvertColToString

func ConvertColToString(col int) (string, error)

ConvertColToString

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

func ConvertRowColToAxis

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

ConvertRowColToAxis

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

func ConvertRowToString

func ConvertRowToString(row int) (string, error)

func NewEmptyFile

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

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

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