forked from scraperwiki/xlsx
-
Notifications
You must be signed in to change notification settings - Fork 0
/
main.go
67 lines (56 loc) · 1.05 KB
/
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
57
58
59
60
61
62
63
64
65
66
67
package main
import (
"os"
"github.com/psmithuk/xlsx"
)
func main() {
outputfile, err := os.Create("test.xlsx")
if err != nil {
panic(err)
}
ww := xlsx.NewWorkbookWriter(outputfile)
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)
sh.Title = "MySheet"
sw, err := ww.NewSheetWriter(&sh)
if err != nil {
panic(err)
}
r := sh.NewRow()
r.Cells[0] = xlsx.Cell{
Type: xlsx.CellTypeInlineString,
Value: "Spanning Title",
Colspan: 2,
}
r.Cells[2] = xlsx.Cell{
Type: xlsx.CellTypeInlineString,
Value: "Hello",
Rowspan: 2,
}
err = sw.WriteRows([]xlsx.Row{r})
if err != nil {
panic(err)
}
r = sh.NewRow()
r.Cells[0] = xlsx.Cell{
Type: xlsx.CellTypeNumber,
Value: "5",
}
r.Cells[1] = xlsx.Cell{
Type: xlsx.CellTypeNumber,
Value: "10",
}
err = sw.WriteRows([]xlsx.Row{r})
if err != nil {
panic(err)
}
err = ww.Close()
if err != nil {
panic(err)
}
defer outputfile.Close()
}