golang对.xlsx文件的写入和读取,利用第三包github.com/tealeg/xlsx
```
package main
import (
"fmt"
"github.com/tealeg/xlsx"
)
type Member struct {
Name string `xlsx:"0"`
Age int `xlsx:"1"`
}
func main() {
WriteToXlsx()
ReadXlsx()
}
//把Member结构的数据写入到.xlsx文件当中
func WriteToXlsx() {
var file *xlsx.File
var sheet *xlsx.Sheet
var row *xlsx.Row
var err error
file = xlsx.NewFile()
sheet, err = file.AddSheet("Sheet1")
if err != nil {
fmt.Printf(err.Error())
}
row = sheet.AddRow()
member := &Member{"A1", 21}
a := row.WriteStruct(member, -1)
fmt.Println(a)
file.Save("MyXLSXFile.xlsx")
}
//把.xlsx文件的内容读取到Member结构体中.
func ReadXlsx() {
xlFile, err := xlsx.OpenFile("MyXLSXFile.xlsx")
if err != nil {
fmt.Println("err:", err)
}
members := make([]Member, 0)
member := new(Member)
length := xlFile.Sheet["Sheet1"].MaxRow
for i := 0; i < length; i++ {
xlFile.Sheet["Sheet1"].Rows[i].ReadStruct(member)
if err != nil {
fmt.Println("err:", err)
break
}
members = append(members, *member)
}
fmt.Println("members:", members)
}
```