使用go-excelize读取Excel指定列的数据

最新推荐文章于 2024-09-19 18:29:03 发布

hxp_area

最新推荐文章于 2024-09-19 18:29:03 发布

阅读量2.4k

点赞数 3

分类专栏： golang 文章标签： go excel

本文链接：https://blog.csdn.net/happy3581/article/details/119425472

版权

golang 专栏收录该内容

1 篇文章 0 订阅

订阅专栏

使用go-excelize读取Excel指定列的数据

func ListCol(excel_path, col string) []string {
	colNum := map[string]int{
		"A": 0,
		"B": 1,
		"C": 2,
		"D": 3,
		"E": 4,
		"F": 5,
		"G": 6,
		"H": 7,
		"I": 8,
		"J": 9,
		"K": 10,
		"L": 11,
		"M": 12,
		"N": 13,
		"O": 14,
		"P": 15,
	}

	xlsx, err := excelize.OpenFile(excel_path)
	if err != nil {
		fmt.Println("open file err:", err)
	}
	sheetname := xlsx.GetSheetName(xlsx.GetActiveSheetIndex())
	rows, _ := xlsx.GetRows(sheetname)
	out := make([]string, 0)
	for _, row := range rows {
		for index, colCel := range row {
			if index == colNum[col] {
				// fmt.Println(colCel)
				out = append(out, colCel)
			}
		}
	}
	return out
}