diff options
| author | Ri Xu <xuri.me@gmail.com> | 2017-06-08 11:11:11 +0800 |
|---|---|---|
| committer | Ri Xu <xuri.me@gmail.com> | 2017-06-08 11:11:11 +0800 |
| commit | c89d84235238f1e2a37b03551ca6ef652c2f3769 (patch) | |
| tree | 6ed520a68e78cca3a4bb9b932a5cdbd4c4cc5499 /excelize_test.go | |
| parent | c5dc63295186ad35ece6a2c9c940e84665f9f98f (diff) | |
Init auto filter support, relate issue #59.
Diffstat (limited to 'excelize_test.go')
| -rw-r--r-- | excelize_test.go | 52 |
1 files changed, 52 insertions, 0 deletions
diff --git a/excelize_test.go b/excelize_test.go index 99c2dd4..ef4cbf8 100644 --- a/excelize_test.go +++ b/excelize_test.go @@ -477,6 +477,19 @@ func TestSheetVisibility(t *testing.T) { } } +func TestRowVisibility(t *testing.T) { + xlsx, err := OpenFile("./test/Workbook_2.xlsx") + if err != nil { + t.Log(err) + } + xlsx.HideRow("Sheet3", 2) + xlsx.UnhideRow("Sheet3", 2) + err = xlsx.Save() + if err != nil { + t.Log(err) + } +} + func TestCopySheet(t *testing.T) { xlsx, err := OpenFile("./test/Workbook_2.xlsx") if err != nil { @@ -541,6 +554,45 @@ func TestAddComments(t *testing.T) { } } +func TestAutoFilter(t *testing.T) { + xlsx, err := OpenFile("./test/Workbook_2.xlsx") + if err != nil { + t.Log(err) + } + err = xlsx.AutoFilter("Sheet3", "D4", "B1", ``) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x != blanks"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x == blanks"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x != nonblanks"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x == nonblanks"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x <= 1 and x >= 2"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x == 1 or x == 2"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x == 1 or x == 2*"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x <= 1 and x >= blanks"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x -- y or x == *2*"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x != y or x ? *2"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x -- y o r x == *2"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"B","expression":"x -- y"}`) + t.Log(err) + err = xlsx.AutoFilter("Sheet3", "D4", "B1", `{"column":"A","expression":"x -- y"}`) + t.Log(err) + err = xlsx.Save() + if err != nil { + t.Log(err) + } +} + func TestAddChart(t *testing.T) { xlsx, err := OpenFile("./test/Workbook1.xlsx") if err != nil { |