protectWorkbook | R Documentation |
Protect or unprotect a workbook from modifications by the user in the graphical user interface. Replaces an existing protection.
protectWorkbook( wb, protect = TRUE, password = NULL, lockStructure = FALSE, lockWindows = FALSE, type = 1L )
wb |
A workbook object |
protect |
Whether to protect or unprotect the sheet (default=TRUE) |
password |
(optional) password required to unprotect the workbook |
lockStructure |
Whether the workbook structure should be locked |
lockWindows |
Whether the window position of the spreadsheet should be locked |
type |
Lock type, default 1. From the xml documentation: 1 - Document is password protected. 2 - Document is recommended to be opened as read-only. 4 - Document is enforced to be opened as read-only. 8 - Document is locked for annotation. |
Reinhold Kainhofer
wb <- createWorkbook() addWorksheet(wb, "S1") protectWorkbook(wb, protect = TRUE, password = "Password", lockStructure = TRUE) ## Not run: saveWorkbook(wb, "WorkBook_Protection.xlsx", overwrite = TRUE) ## End(Not run) # Remove the protection protectWorkbook(wb, protect = FALSE) ## Not run: saveWorkbook(wb, "WorkBook_Protection_unprotected.xlsx", overwrite = TRUE) ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.