-
Notifications
You must be signed in to change notification settings - Fork 3
/
column.go
27 lines (23 loc) · 863 Bytes
/
column.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
package excelKit
import "github.com/xuri/excelize/v2"
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
)