From f8667386dcde788d8232b652ac85a138c0d20bf3 Mon Sep 17 00:00:00 2001
From: chenliu1993 <13630583107@163.com>
Date: Sat, 27 Aug 2022 00:45:46 +0800
Subject: This closes #827, add new functions `GetDataValidations` and
 `GetConditionalFormats` (#1315)

Signed-off-by: chenliu1993 <13630583107@163.com>
---
 datavalidation.go | 12 ++++++++++++
 1 file changed, 12 insertions(+)

(limited to 'datavalidation.go')

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.
-- 
cgit v1.2.1