excelKit

package
v3.0.98 Latest Latest
Warning

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

Go to latest
Published: May 29, 2024 License: Apache-2.0 Imports: 4 Imported by: 0

Documentation

Index

Constants

View Source
const (
	// MaxRows
	/*
		PS:
		(1) 从 1 开始
		(2) 范围: [1, 1048576]
	*/
	MaxRows = excelize.TotalRows

	// MaxColumns
	/*
		PS:
		(1) 从 1 开始
		(2) 范围: [1, 16384]
	*/
	MaxColumns = excelize.MaxColumns
)

Variables

View Source
var (
	// CellNameToCoordinates 单元格名 => 坐标(行、列)
	/*
		e.g.
			fmt.Println(excelKit.CellNameToCoordinates("A1")) // 1 1 <nil>
			fmt.Println(excelKit.CellNameToCoordinates("Z3")) // 26 3 <nil>
	*/
	CellNameToCoordinates func(cell string) (col int, row int, err error) = excelize.CellNameToCoordinates

	// CoordinatesToCellName 坐标(行、列) => 单元格名
	/*
		e.g.
			fmt.Println(excelKit.CoordinatesToCellName(1, 1))       // A1 <nil>
			fmt.Println(excelKit.CoordinatesToCellName(1, 1, true)) // $A$1 <nil>
	*/
	CoordinatesToCellName func(col, row int, abs ...bool) (cellName string, err error) = excelize.CoordinatesToCellName

	// JoinCellName
	/*
		e.g.
			fmt.Println(excelKit.JoinCellName("C", 3)) // C3 <nil>
	*/
	JoinCellName func(col string, row int) (cellName string, err error) = excelize.JoinCellName

	// SplitCellName
	/*
		e.g.
			fmt.Println(excelKit.SplitCellName("C3")) // C 3 <nil>
			fmt.Println(excelKit.SplitCellName("c3")) // c 3 <nil>
	*/
	SplitCellName func(cell string) (col string, row int, err error) = excelize.SplitCellName
)
View Source
var (
	// ColumnNumberToName 列数字 => 列名
	/*
		@param num 有效范围: [1, 16384]

		e.g.
			fmt.Println(excelKit.ColumnNumberToName(1))  // A <nil>
			fmt.Println(excelKit.ColumnNumberToName(2))  // B <nil>
			fmt.Println(excelKit.ColumnNumberToName(10)) // J <nil>
			fmt.Println(excelKit.ColumnNumberToName(37)) // AK <nil>
	*/
	ColumnNumberToName func(num int) (string, error) = excelize.ColumnNumberToName

	// ColumnNameToNumber 列名 => 列数字
	/*
		e.g.
			fmt.Println(excelKit.ColumnNameToNumber("A"))  // 1 <nil>
			fmt.Println(excelKit.ColumnNameToNumber("a"))  // 1 <nil>
			fmt.Println(excelKit.ColumnNameToNumber("B"))  // 2 <nil>
			fmt.Println(excelKit.ColumnNameToNumber("AK")) // 37 <nil>
	*/
	ColumnNameToNumber func(name string) (int, error) = excelize.ColumnNameToNumber
)
View Source
var NewFile func(opts ...excelize.Options) *excelize.File = excelize.NewFile

NewFile 新建一个空白的Excel文件.

PS: (1) 返回的 *excelize.File实例,不再使用时应当调用 File.Close(); (2) 新建的空白的Excel文件,其内只有1个空白的工作表,表名为"Sheet1".

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

OpenReader 打开数据流.

PS: 可能会返回 excelize.ErrWorkbookFileFormat,原因: 文件格式不支持(比如.xls文件).

@params r 数据流(包括: 远程文件)

Functions

func GetActiveSheetName added in v3.0.38

func GetActiveSheetName(f *excelize.File) string

func GetCellType added in v3.0.38

func GetCellType(f *excelize.File, sheetName string, col, row int) (excelize.CellType, error)

func GetCellValue added in v3.0.38

func GetCellValue(f *excelize.File, sheetName string, col, row int, opts ...excelize.Options) (string, error)

func NewFileWithPath

func NewFileWithPath(filePath string, opts ...excelize.Options) (*excelize.File, error)

NewFileWithPath 新建一个空白的Excel文件.

PS: (1) 返回的 *excelize.File实例,不再使用时应当调用 File.Close(); (2) 新建的空白的Excel文件,其内只有1个空白的工作表,表名为"Sheet1".

@param path 文件的路径(如果文件已经存在,会覆盖它)

func OpenFile

func OpenFile(filePath string, opts ...excelize.Options) (*excelize.File, error)

OpenFile 打开本地文件.

PS: 可能会返回 excelize.ErrWorkbookFileFormat,原因: 文件格式不支持(比如.xls文件).

func SetCellBool added in v3.0.38

func SetCellBool(f *excelize.File, sheetName string, col, row int, value bool) error

func SetCellFloat added in v3.0.38

func SetCellFloat(f *excelize.File, sheetName string, col, row int, value float64, precision, bitSize int) error

func SetCellInt added in v3.0.38

func SetCellInt(f *excelize.File, sheetName string, col, row int, value int) error

func SetCellStr added in v3.0.38

func SetCellStr(f *excelize.File, sheetName string, col, row int, value string) error

func SetCellUint added in v3.0.38

func SetCellUint(f *excelize.File, sheetName string, col, row int, value uint64) error

func SetCellValue added in v3.0.38

func SetCellValue(f *excelize.File, sheetName string, col, row int, value interface{}) error

SetCellValue 设置单元格的值.

@param sheetName 工作表名 @param col [1, 16384] @param row [1, 1048576]

Types

This section is empty.

Jump to

Keyboard shortcuts

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