diff options
author | Ri Xu <xuri.me@gmail.com> | 2017-05-24 14:17:35 +0800 |
---|---|---|
committer | Ri Xu <xuri.me@gmail.com> | 2017-05-24 14:17:35 +0800 |
commit | dea57dd0aeb5507dc4f58de48b261d4013364232 (patch) | |
tree | b6c8b73affc39acb5a4305eac86cd48792446b44 /sheet.go | |
parent | 70f6328150aa954cd9721e90883f001ea005c1ee (diff) |
Code optimize.
Diffstat (limited to 'sheet.go')
-rw-r--r-- | sheet.go | 13 |
1 files changed, 10 insertions, 3 deletions
@@ -437,13 +437,20 @@ 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. +// 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) { name = trimSheetName(name) content := f.workbookReader() count := 0 for _, v := range content.Sheets.Sheet { - if v.State != sheetStateHidden { + if v.State != `hidden` { count++ } } @@ -455,7 +462,7 @@ func (f *File) HideSheet(name string) { tabSelected = xlsx.SheetViews.SheetView[0].TabSelected } if v.Name == name && count > 1 && !tabSelected { - content.Sheets.Sheet[k].State = sheetStateHidden + content.Sheets.Sheet[k].State = `hidden` } } } |