forked from scraperwiki/xlsx
-
Notifications
You must be signed in to change notification settings - Fork 0
/
main.go
56 lines (45 loc) · 980 Bytes
/
main.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
package main
import (
"time"
"github.com/psmithuk/xlsx"
)
func main() {
c := []xlsx.Column{
xlsx.Column{Name: "Col1", Width: 10},
xlsx.Column{Name: "Col2", Width: 10},
xlsx.Column{Name: "Col3", Width: 10},
}
sh := xlsx.NewSheetWithColumns(c)
r := sh.NewRow()
r.Cells[0] = xlsx.Cell{
Type: xlsx.CellTypeNumber,
Value: "10",
}
r.Cells[1] = xlsx.Cell{
Type: xlsx.CellTypeString,
Value: "Apple",
}
r.Cells[2] = xlsx.Cell{
Type: xlsx.CellTypeDatetime,
Value: time.Date(1980, 4, 24, 0, 0, 0, 0, time.UTC).Format(time.RFC3339),
}
sh.AppendRow(r)
r2 := sh.NewRow()
r2.Cells[0] = xlsx.Cell{
Type: xlsx.CellTypeNumber,
Value: "10",
}
r2.Cells[1] = xlsx.Cell{
Type: xlsx.CellTypeString,
Value: "Apple",
}
r2.Cells[2] = xlsx.Cell{
Type: xlsx.CellTypeDatetime,
Value: time.Date(2008, 1, 9, 0, 0, 0, 0, time.UTC).Format(time.RFC3339),
}
sh.AppendRow(r2)
err := sh.SaveToFile("test.xlsx")
if err != nil {
println(err)
}
}