gexcel

Documentation

Index

• type GExcel
  • func (xlsx GExcel) OpenAsColumn2Map() []map[string]string
  • func (xlsx GExcel) OpenAsColumn2Slice() [][]string
  • func (xlsx GExcel) Save()

Types

type GExcel

type GExcel struct {
	FileName  string
	SheetName string
	Header    []string
	Data      [][]string
}

GExcel ... 自定义Excel

func (GExcel) OpenAsColumn2Map

func (xlsx GExcel) OpenAsColumn2Map() []map[string]string

OpenAsColumn2Map ... 打开Excel，需要先执行Save的demo保存一波

rr := gexcel.GExcel{
	FileName:  "test.xlsx",
	SheetName: "Sheet1",
}.OpenAsColumn2Map()

bt, _ := json.Marshal(rr)
fmt.Println(string(bt))

func (GExcel) OpenAsColumn2Slice

func (xlsx GExcel) OpenAsColumn2Slice() [][]string

OpenAsColumn2Slice ... 打开Excel

func (GExcel) Save

func (xlsx GExcel) Save()

Save ... 保存Excel

header := []string{}
data := [][]string{}
rowData := []string{}
for i := 1; i < 10; i++ {
	header = append(header, fmt.Sprintf("第 %d 列", i))
	rowData = append(rowData, fmt.Sprintf("col value %d", i))
}

for i := 1; i < 10; i++ {
	data = append(data, rowData)
}

xlsx := gexcel.GExcel{
	FileName:  "test.xlsx",
	SheetName: "Sheet1",
	Header:    header,
	Data:      data,
}
xlsx.Save()