diff options
Diffstat (limited to 'sheet.go')
-rw-r--r-- | sheet.go | 8 |
1 files changed, 7 insertions, 1 deletions
@@ -713,7 +713,7 @@ func (f *File) SearchSheet(sheet, value string) []string { // ProtectSheet provides a function to prevent other users from accidentally // or deliberately changing, moving, or deleting data in a worksheet. For -// example protect Sheet1 with protection settings: +// example, protect Sheet1 with protection settings: // // xlsx.ProtectSheet("Sheet1", &excelize.FormatSheetProtection{ // Password: "password", @@ -752,6 +752,12 @@ func (f *File) ProtectSheet(sheet string, settings *FormatSheetProtection) { } } +// UnprotectSheet provides a function to unprotect an Excel worksheet. +func (f *File) UnprotectSheet(sheet string) { + xlsx := f.workSheetReader(sheet) + xlsx.SheetProtection = nil +} + // trimSheetName provides a function to trim invaild characters by given worksheet // name. func trimSheetName(name string) string { |