-
Notifications
You must be signed in to change notification settings - Fork 0
/
with_tag.go
64 lines (57 loc) · 1.21 KB
/
with_tag.go
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
package main
import (
"fmt"
"github.com/360EntSecGroup-Skylar/excelize"
zero "github.com/wangbei98/excelizero"
"github.com/wangbei98/excelizero/example"
)
func main() {
var err error
u := example.UserWithTag{
Name: "Jack",
Age: 11,
Height: 180,
}
u2 := example.UserWithTag{
Name: "Jack2",
Age: 222,
Height: 190,
}
var l []example.UserWithTag
l = append(l, u, u2)
f := excelize.NewFile()
excelizero := zero.NewExcelizero(f)
// insert slice of structs
err = excelizero.WriteStructWithTag("Sheet1", 1, l)
if err != nil {
fmt.Println(err)
}
err = excelizero.SaveAs("example/with-tag/multi_with_tag.xlsx")
if err != nil {
fmt.Println(err)
}
// ################################
uu := example.UserWithTag2{
Name: "Jack",
Age: 11,
Height: 180,
}
uu2 := example.UserWithTag2{
Name: "Jack2",
Age: 222,
Height: 190,
}
var ll []example.UserWithTag2
ll = append(ll, uu, uu2)
ff := excelize.NewFile()
excelizero2 := zero.NewExcelizero(ff)
// insert slice of structs
err = excelizero2.WriteStructWithTag("Sheet1", 1, ll)
if err != nil {
fmt.Println(err)
}
err = excelizero2.SaveAs("example/with-tag/multi_with_tag2.xlsx")
if err != nil {
fmt.Println(err)
}
}