summaryrefslogtreecommitdiff
path: root/excelize_test.go
diff options
context:
space:
mode:
authorRi Xu <xuri.me@gmail.com>2017-07-30 12:40:59 +0800
committerRi Xu <xuri.me@gmail.com>2017-07-30 12:40:59 +0800
commitbbed2f6dc9d73bb6ab6e0c7923c18acdafa13cd5 (patch)
tree803acdcd8fc1e0c3e5fd97c51ca9ee135507c507 /excelize_test.go
parent961996a8132eda8671d2de45fe21bfeb43866752 (diff)
- Init create or remove panes support;
- go test updated
Diffstat (limited to 'excelize_test.go')
-rw-r--r--excelize_test.go19
1 files changed, 18 insertions, 1 deletions
diff --git a/excelize_test.go b/excelize_test.go
index 5b942e1..613da1b 100644
--- a/excelize_test.go
+++ b/excelize_test.go
@@ -142,6 +142,7 @@ func TestBrokenFile(t *testing.T) {
// Test set active sheet without BookViews and Sheets maps in xl/workbook.xml.
f3, err := OpenFile("./test/badWorkbook.xlsx")
+ f3.GetActiveSheetIndex()
f3.SetActiveSheet(2)
if err != nil {
t.Log(err)
@@ -563,7 +564,8 @@ func TestSetDeleteSheet(t *testing.T) {
t.Log(err)
}
xlsx.DeleteSheet("Sheet1")
- err = xlsx.Save()
+ xlsx.AddComment("Sheet1", "A1", `{"author":"Excelize: ","text":"This is a comment."}`)
+ err = xlsx.SaveAs("./test/Workbook_delete_sheet.xlsx")
if err != nil {
t.Log(err)
}
@@ -832,6 +834,21 @@ func TestInsertRow(t *testing.T) {
}
}
+func TestSetPane(t *testing.T) {
+ xlsx := NewFile()
+ xlsx.SetPanes("Sheet1", `{"freeze":false,"split":false}`)
+ xlsx.NewSheet(2, "Panes 2")
+ xlsx.SetPanes("Sheet2", `{"freeze":true,"split":false,"x_split":1,"y_split":0,"top_left_cell":"B1","active_pane":"topRight","panes":[{"sqref":"K16","active_cell":"K16","pane":"topRight"}]}`)
+ xlsx.NewSheet(3, "Panes 3")
+ xlsx.SetPanes("Sheet3", `{"freeze":false,"split":true,"x_split":3270,"y_split":1800,"top_left_cell":"N57","active_pane":"bottomLeft","panes":[{"sqref":"I36","active_cell":"I36"},{"sqref":"G33","active_cell":"G33","pane":"topRight"},{"sqref":"J60","active_cell":"J60","pane":"bottomLeft"},{"sqref":"O60","active_cell":"O60","pane":"bottomRight"}]}`)
+ xlsx.NewSheet(4, "Panes 4")
+ xlsx.SetPanes("Sheet4", `{"freeze":true,"split":false,"x_split":0,"y_split":9,"top_left_cell":"A34","active_pane":"bottomLeft","panes":[{"sqref":"A11:XFD11","active_cell":"A11","pane":"bottomLeft"}]}`)
+ err := xlsx.SaveAs("./test/Workbook_set_panes.xlsx")
+ if err != nil {
+ t.Log(err)
+ }
+}
+
func TestRemoveRow(t *testing.T) {
xlsx := NewFile()
for j := 1; j <= 10; j++ {