summaryrefslogtreecommitdiff
path: root/sheet.go
diff options
context:
space:
mode:
Diffstat (limited to 'sheet.go')
-rw-r--r--sheet.go8
1 files changed, 7 insertions, 1 deletions
diff --git a/sheet.go b/sheet.go
index 8ddb8c9..9861d20 100644
--- a/sheet.go
+++ b/sheet.go
@@ -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 {