diff options
Diffstat (limited to 'datavalidation.go')
| -rw-r--r-- | datavalidation.go | 14 |
1 files changed, 9 insertions, 5 deletions
diff --git a/datavalidation.go b/datavalidation.go index 3035bb2..e5ea5a5 100644 --- a/datavalidation.go +++ b/datavalidation.go @@ -208,7 +208,7 @@ func convDataValidationOperatior(o DataValidationOperator) string { // dvRange.Sqref = "A1:B2" // dvRange.SetRange(10, 20, excelize.DataValidationTypeWhole, excelize.DataValidationOperatorBetween) // dvRange.SetError(excelize.DataValidationErrorStyleStop, "error title", "error body") -// xlsx.AddDataValidation("Sheet1", dvRange) +// err := xlsx.AddDataValidation("Sheet1", dvRange) // // Example 2, set data validation on Sheet1!A3:B4 with validation criteria // settings, and show input message when cell is selected: @@ -217,7 +217,7 @@ func convDataValidationOperatior(o DataValidationOperator) string { // dvRange.Sqref = "A3:B4" // dvRange.SetRange(10, 20, excelize.DataValidationTypeWhole, excelize.DataValidationOperatorGreaterThan) // dvRange.SetInput("input title", "input body") -// xlsx.AddDataValidation("Sheet1", dvRange) +// err = xlsx.AddDataValidation("Sheet1", dvRange) // // Example 3, set data validation on Sheet1!A5:B6 with validation criteria // settings, create in-cell dropdown by allowing list source: @@ -225,13 +225,17 @@ func convDataValidationOperatior(o DataValidationOperator) string { // dvRange = excelize.NewDataValidation(true) // dvRange.Sqref = "A5:B6" // dvRange.SetDropList([]string{"1", "2", "3"}) -// xlsx.AddDataValidation("Sheet1", dvRange) +// err = xlsx.AddDataValidation("Sheet1", dvRange) // -func (f *File) AddDataValidation(sheet string, dv *DataValidation) { - xlsx := f.workSheetReader(sheet) +func (f *File) AddDataValidation(sheet string, dv *DataValidation) error { + xlsx, err := f.workSheetReader(sheet) + if err != nil { + return err + } if nil == xlsx.DataValidations { xlsx.DataValidations = new(xlsxDataValidations) } xlsx.DataValidations.DataValidation = append(xlsx.DataValidations.DataValidation, dv) xlsx.DataValidations.Count = len(xlsx.DataValidations.DataValidation) + return err } |