golang处理excel文件

写文件

github.com/xuri/excelize/v2

github.com/xuri/excelize/v2excelize.NewFile()

f.SetCellValue()Sheet1

f.SaveAs()

github.com/xuri/excelize/v2

example.xlsx

github.com/xuri/excelize/v2excelize

读文件

github.com/xuri/excelize/v2

github.com/xuri/excelize/v2excelize.OpenFile()

f.GetRows()Sheet1rows

rows

github.com/xuri/excelize/v2

example.xlsxSheet1

github.com/xuri/excelize/v2excelize

获取某一行某一列具体的值

github.com/xuri/excelize/v2

github.com/xuri/excelize/v2excelize.OpenFile()

f.GetCellValue()Sheet1B2cellValue

最后，我们打印出获取到的单元格的值。

github.com/xuri/excelize/v2

example.xlsxSheet1B2

github.com/xuri/excelize/v2excelize