This closes #827, add new functions `GetDataValidations` and `GetConditionalFormats` (#1315)

Signed-off-by: chenliu1993 <13630583107@163.com>

1 files changed, 12 insertions, 0 deletions

diff --git a/datavalidation.go b/datavalidation.go
index 0cad1b8..3d82f7c 100644
--- a/datavalidation.go
+++ b/datavalidation.go
@@ -259,6 +259,18 @@ func (f *File) AddDataValidation(sheet string, dv *DataValidation) error {
 	return err
 }
 
+// GetDataValidations returns data validations list by given worksheet name.
+func (f *File) GetDataValidations(sheet string) ([]*DataValidation, error) {
+	ws, err := f.workSheetReader(sheet)
+	if err != nil {
+		return nil, err
+	}
+	if ws.DataValidations == nil || len(ws.DataValidations.DataValidation) == 0 {
+		return nil, err
+	}
+	return ws.DataValidations.DataValidation, err
+}
+
 // DeleteDataValidation delete data validation by given worksheet name and
 // reference sequence. All data validations in the worksheet will be deleted
 // if not specify reference sequence parameter.