代码拉取完成,页面将自动刷新
// 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))
}
此处可能存在不合适展示的内容,页面不予展示。您可通过相关编辑功能自查并修改。
如您确认内容无涉及 不当用语 / 纯广告导流 / 暴力 / 低俗色情 / 侵权 / 盗版 / 虚假 / 无价值内容或违法国家有关法律法规的内容,可点击提交进行申诉,我们将尽快为您处理。