diff options
Diffstat (limited to 'sheet_test.go')
-rw-r--r-- | sheet_test.go | 34 |
1 files changed, 34 insertions, 0 deletions
diff --git a/sheet_test.go b/sheet_test.go index 1a59b65..4626003 100644 --- a/sheet_test.go +++ b/sheet_test.go @@ -3,6 +3,7 @@ package excelize import ( "fmt" "path/filepath" + "strconv" "strings" "testing" @@ -344,3 +345,36 @@ func TestSetSheetName(t *testing.T) { f.SetSheetName("Sheet1", "Sheet1") assert.Equal(t, "Sheet1", f.GetSheetName(0)) } + +func BenchmarkNewSheet(b *testing.B) { + b.RunParallel(func(pb *testing.PB) { + for pb.Next() { + newSheetWithSet() + } + }) +} +func newSheetWithSet() { + file := NewFile() + file.NewSheet("sheet1") + for i := 0; i < 1000; i++ { + file.SetCellInt("sheet1", "A"+strconv.Itoa(i+1), i) + } + file = nil +} + +func BenchmarkFile_SaveAs(b *testing.B) { + b.RunParallel(func(pb *testing.PB) { + for pb.Next() { + newSheetWithSave() + } + + }) +} +func newSheetWithSave() { + file := NewFile() + file.NewSheet("sheet1") + for i := 0; i < 1000; i++ { + file.SetCellInt("sheet1", "A"+strconv.Itoa(i+1), i) + } + file.Save() +} |