Password protected sheet or range

[FranLegon]

Excel allows for the protection of sheets and even specific ranges using a password:


Can this feature be implemented into excelize?
Thanks in advance!

Note: #199 refers to password-protecting an entire xlsx file and that issue has been solved.

[xuri]

Thanks for your issue. Please reference the documentation of the ProtectSheet function. For example:

err := f.ProtectSheet("Sheet1", &excelize.SheetProtectionOptions{
    Password:            "password",
    SelectUnlockedCells: true,
    SelectLockedCells:   true,
})

Also reference the related issues #736 and #1511. I've closed this issue, if you have any questions, please let me know, and you can reopen this anytime.

[FranLegon]

Thanks a lot! Sorry about the unnecessary request. Great work btw.