1. 获取 Excel  单元格坐标 - 摘录自 github.com/360EntSecGroup-Skylar/excelize

/* 下面两个函数获取Excel 单元格坐标 */

func ColumnNumberToName(num int) (string, error) {

if num < 1 {

return "", fmt.Errorf("incorrect column number %d", num)

}

var col string

for num > 0 {

col = string((num-1)%26+65) + col

num = (num - 1) / 26

}

return col, nil

}

func CoordinatesToCellName(col, row int) (string, error) {

if col < 1 || row < 1 {

return "", fmt.Errorf("invalid cell coordinates [%d, %d]", col, row)

}

colname, err := ColumnNumberToName(col)

if err != nil {

return "", fmt.Errorf("invalid cell coordinates [%d, %d]: %v", col, row, err)

}

return fmt.Sprintf("%s%d", colname, row), nil

}