summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--excelize_test.go1
-rw-r--r--sheet.go8
2 files changed, 7 insertions, 2 deletions
diff --git a/excelize_test.go b/excelize_test.go
index 2b67c9e..b98400c 100644
--- a/excelize_test.go
+++ b/excelize_test.go
@@ -190,6 +190,7 @@ func TestBrokenFile(t *testing.T) {
func TestNewFile(t *testing.T) {
// Test create a XLSX file.
xlsx := NewFile()
+ xlsx.NewSheet("Sheet1")
xlsx.NewSheet("XLSXSheet2")
xlsx.NewSheet("XLSXSheet3")
xlsx.SetCellInt("XLSXSheet2", "A23", 56)
diff --git a/sheet.go b/sheet.go
index ae79acb..bc7cb75 100644
--- a/sheet.go
+++ b/sheet.go
@@ -13,9 +13,13 @@ import (
)
// NewSheet provides function to create a new sheet by given index, when
-// creating a new XLSX file, the default sheet will be create, when you create a
-// new file.
+// creating a new XLSX file, the default sheet will be create, when you create
+// a new file.
func (f *File) NewSheet(name string) int {
+ // Check if the worksheet already exists
+ if f.GetSheetIndex(name) != 0 {
+ return f.SheetCount
+ }
f.SheetCount++
// Update docProps/app.xml
f.setAppXML()