forked from 36150592/unioffice
-
Notifications
You must be signed in to change notification settings - Fork 0
/
main.go
44 lines (36 loc) · 815 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
// Copyright 2017 Baliance. All rights reserved.
package main
import (
"log"
"math/rand"
"baliance.com/gooxml/spreadsheet"
)
func main() {
ss := spreadsheet.New()
sheet := ss.AddSheet()
row := sheet.AddRow()
row.AddCell()
for i := 0; i < 99; i++ {
row.AddCell().SetString("Header")
}
for i := 0; i < 100; i++ {
row = sheet.AddRow()
row.AddCell().SetString("Header")
for j := 0; j < 99; j++ {
row.AddCell().SetNumber(rand.Float64() * 100)
}
}
// freeze the first row and column
sheet.SetFrozen(true, true)
/* this is equivalent to
v := sheet.InitialView()
v.SetState(sml.ST_PaneStateFrozen)
v.SetYSplit(1)
v.SetXSplit(1)
v.SetTopLeft("B2")
*/
if err := ss.Validate(); err != nil {
log.Fatalf("error validating sheet: %s", err)
}
ss.SaveToFile("freeze-rows-cols.xlsx")
}