引用包
github.com/xuri/excelize/v2
导出
func main() {
f := excelize.NewFile()
index := f.NewSheet("Sheet2")
f.SetCellValue("Sheet1", "B2", 100)
f.SetCellValue("Sheet2", "A2", "Hello world.")
f.SetActiveSheet(index)
if err := f.SaveAs("../Book1.xlsx"); err != nil {
fmt.Println(err)
}
}
导入
f, err := excelize.OpenFile("Book1.xlsx")
if err != nil {
fmt.Println(err)
return
}
cell, err := f.GetCellValue("Sheet1", "B2")
if err != nil {
fmt.Println(err)
return
}
fmt.Println(cell)
rows, err := f.GetRows("Sheet1")
if err != nil {
fmt.Println(err)
return
}
for _, row := range rows {
for _, colCell := range row {
fmt.Print(colCell, "\t")
}
fmt.Println()
}
对流进行操作
openFile, _ := os.OpenFile("/Book1.xlsx", os.O_WRONLY, os.ModeAppend)
f, _ := excelize.OpenReader(openFile)