summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--excelize_test.go13
1 files changed, 13 insertions, 0 deletions
diff --git a/excelize_test.go b/excelize_test.go
index 9f738f3..d021b55 100644
--- a/excelize_test.go
+++ b/excelize_test.go
@@ -1195,6 +1195,19 @@ func TestHSL(t *testing.T) {
t.Log(RGBToHSL(250, 50, 100))
}
+func TestSearchSheet(t *testing.T) {
+ xlsx, err := OpenFile("./test/SharedStrings.xlsx")
+ if err != nil {
+ t.Error(err)
+ return
+ }
+ // Test search in a not exists worksheet.
+ t.Log(xlsx.SearchSheet("Sheet4", ""))
+ // Test search a not exists value.
+ t.Log(xlsx.SearchSheet("Sheet1", "X"))
+ t.Log(xlsx.SearchSheet("Sheet1", "A"))
+}
+
func trimSliceSpace(s []string) []string {
for {
if len(s) > 0 && s[len(s)-1] == "" {