From a9f671d98f85585e7f77c73554f3c1ad897c4fd1 Mon Sep 17 00:00:00 2001
From: Ri Xu <xuri.me@gmail.com>
Date: Wed, 14 Jun 2017 15:01:49 +0800
Subject: - New functions: `GetSheetVisible()` and `GetRowVisible()` added,
 relate issue #61; - go test updated

---
 sheet.go | 36 ++++++++++++++++++++++++++++--------
 1 file changed, 28 insertions(+), 8 deletions(-)

(limited to 'sheet.go')

diff --git a/sheet.go b/sheet.go
index f67ca9f..a951680 100644
--- a/sheet.go
+++ b/sheet.go
@@ -435,19 +435,31 @@ func (f *File) copySheet(from, to int) {
 	}
 }
 
-// HideSheet provides function to hide worksheet by given name. A workbook must
-// contain at least one visible worksheet. If the given worksheet has been
-// activated, this setting will be invalidated. Sheet state values as defined by
-// http://msdn.microsoft.com/en-
+// SetSheetVisible provides function to set worksheet visible by given worksheet
+// name. A workbook must contain at least one visible worksheet. If the given
+// worksheet has been activated, this setting will be invalidated. Sheet state
+// values as defined by http://msdn.microsoft.com/en-
 // us/library/office/documentformat.openxml.spreadsheet.sheetstatevalues.aspx
 //
 //    visible
 //    hidden
 //    veryHidden
 //
-func (f *File) HideSheet(name string) {
+// For example, hide Sheet1:
+//
+//    xlsx.SetSheetVisible("Sheet1", false)
+//
+func (f *File) SetSheetVisible(name string, visible bool) {
 	name = trimSheetName(name)
 	content := f.workbookReader()
+	if visible {
+		for k, v := range content.Sheets.Sheet {
+			if v.Name == name {
+				content.Sheets.Sheet[k].State = ""
+			}
+		}
+		return
+	}
 	count := 0
 	for _, v := range content.Sheets.Sheet {
 		if v.State != "hidden" {
@@ -467,15 +479,23 @@ func (f *File) HideSheet(name string) {
 	}
 }
 
-// UnhideSheet provides function to unhide worksheet by given name.
-func (f *File) UnhideSheet(name string) {
+// GetSheetVisible provides function to get worksheet visible by given worksheet
+// name. For example, get visible state of Sheet1:
+//
+//    xlsx.GetSheetVisible("Sheet1")
+//
+func (f *File) GetSheetVisible(name string) bool {
 	name = trimSheetName(name)
 	content := f.workbookReader()
+	visible := false
 	for k, v := range content.Sheets.Sheet {
 		if v.Name == name {
-			content.Sheets.Sheet[k].State = ""
+			if content.Sheets.Sheet[k].State == "" || content.Sheets.Sheet[k].State == "visible" {
+				visible = true
+			}
 		}
 	}
+	return visible
 }
 
 // trimSheetName provides function to trim invaild characters by given worksheet
-- 
cgit v1.2.1