1. 引入execl依赖包
go get github.com/xuri/excelize/v2
2. 打开execl文件,并获取句柄
// 打开文件,获取句柄
f, err := excelize.OpenFile(path)
if err != nil {
fmt.Println("OpenFile failed: ", err)
return
}
3. 获取execl的Sheet列表
// 获取execl的Sheet列表
sheets := f.GetSheetList()
if len(sheets) <= 0 {
fmt.Println("GetSheetList failed: ", err)
return
}
4. 获取Sheet1的数据
// 获取Sheet1的数据
rows, err := f.GetRows(sheets[0])
if err != nil {
fmt.Println("GetSheetList failed", err)
return
}
5. 对rows的数据进行处理
package main
import (
"fmt"
"github.com/xuri/excelize/v2"
)
func main() {
f, err := excelize.OpenFile("./test.xlsx")
if err != nil {
fmt.Println("OpenFile failed: ", err)
return
}
// Get all the rows from all sheet.
sheets := f.GetSheetList()
if len(sheets) <= 0 {
fmt.Println("GetSheetList failed: ", err)
return
}
rows, err := f.GetRows(sheets[0])
if err != nil {
fmt.Println("GetSheetList failed", err)
return
}
fmt.Println("rows", rows)
}