summaryrefslogtreecommitdiff
path: root/datavalidation_test.go
diff options
context:
space:
mode:
Diffstat (limited to 'datavalidation_test.go')
-rw-r--r--datavalidation_test.go32
1 files changed, 32 insertions, 0 deletions
diff --git a/datavalidation_test.go b/datavalidation_test.go
new file mode 100644
index 0000000..718131f
--- /dev/null
+++ b/datavalidation_test.go
@@ -0,0 +1,32 @@
+package excelize
+
+import (
+ "testing"
+)
+
+func TestDataValidation(t *testing.T) {
+ xlsx := NewFile()
+
+ dvRange := NewDataValidation(true)
+ dvRange.Sqref = "A1:B2"
+ dvRange.SetRange(10, 20, DataValidationTypeWhole, DataValidationOperatorBetween)
+ dvRange.SetError(DataValidationErrorStyleStop, "error title", "error body")
+ xlsx.AddDataValidation("Sheet1", dvRange)
+
+ dvRange = NewDataValidation(true)
+ dvRange.Sqref = "A3:B4"
+ dvRange.SetRange(10, 20, DataValidationTypeWhole, DataValidationOperatorGreaterThan)
+ dvRange.SetInput("input title", "input body")
+ xlsx.AddDataValidation("Sheet1", dvRange)
+
+ dvRange = NewDataValidation(true)
+ dvRange.Sqref = "A5:B6"
+ dvRange.SetDropList([]string{"1", "2", "3"})
+ xlsx.AddDataValidation("Sheet1", dvRange)
+
+ // Test write file to given path.
+ err := xlsx.SaveAs("./test/Bookdatavalition.xlsx")
+ if err != nil {
+ t.Error(err)
+ }
+}