forked from 36150592/unioffice
/
main.go
60 lines (50 loc) · 1.17 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
// Copyright 2017 Baliance. All rights reserved.
package main
import (
"flag"
"fmt"
"log"
"os"
"runtime/pprof"
"time"
"baliance.com/gooxml/spreadsheet"
)
var cpuprofile = flag.String("cpuprofile", "", "write cpu profile to file")
func main() {
flag.Parse()
if *cpuprofile != "" {
f, err := os.Create(*cpuprofile)
if err != nil {
log.Fatal(err)
}
pprof.StartCPUProfile(f)
defer pprof.StopCPUProfile()
}
start := time.Now()
ss := spreadsheet.New()
nRows := 30000
nCols := 100
sheet := ss.AddSheet()
// rows
for r := 0; r < nRows; r++ {
row := sheet.AddRow()
// and cells
for c := 0; c < nCols; c++ {
cell := row.AddCell()
cell.SetNumber(float64(r + c))
}
}
if err := ss.Validate(); err != nil {
log.Fatalf("error validating sheet: %s", err)
}
fmt.Printf("creating %d rows * %d cells took %s\n", nRows, nCols, time.Now().Sub(start))
ss.SaveToFile("lots-of-rows.xlsx")
start = time.Now()
fmt.Printf("saving took %s\n", time.Now().Sub(start))
start = time.Now()
_, err := spreadsheet.Open("lots-of-rows.xlsx")
if err != nil {
log.Fatalf("error opening sheet: %s", err)
}
fmt.Printf("reading took %s\n", time.Now().Sub(start))
}