golang中的excel上传,读取数据
package test import "github.com/plandem/xlsx"
//学生结构体 type Stu struct { Name string Age string } //读取表中数据,返回list func RedExcel()([]Stu) { filePath :="./test.xlsx" list := make([]Stu,0) //定义表头映射的字段数组 head:=[]string{"name","age"} xl, err := xlsx.Open(filePath) if err != nil { fmt.Print("err") return list } defer xl.Close() sheet := xl.Sheet(0, xlsx.SheetModeStream) totalCols, totalRows := sheet.Dimension() for row := 1; row < totalRows; row++ { stu := Stu{ Name: "", Age: "", } for col := 0; col < totalCols; col++ { value := sheet.Cell(col, row).String() field :=head[col] switch field { case "name": stu.Name=value case "age": stu.Age=value } } list=append(list,stu) } return list }
初玩博客园,欢迎各位大神指正