Protect one or more sheets in a workbook — wb_protect_worksheets • openxlsx2Extras

Protect one or more sheets in a workbook

Usage

wb_protect_worksheets(
  wb,
  sheet = NULL,
  protect = TRUE,
  password = NULL,
  properties = c("insertColumns", "insertRows", "deleteColumns", "deleteRows")
)

Arguments

wb: A workbook object
sheet: A name or index of a worksheet
protect: Whether to protect or unprotect the sheet (default=TRUE)
password: (optional) password required to unprotect the worksheet
properties: Defaults to c("insertColumns", "insertRows", "deleteColumns", "deleteRows")

Value

A wbWorkbook object.

Examples

wb <- as_wb(mtcars[1:3, ])

wb_protect_worksheets(wb)
#> A Workbook object.
#>  
#> Worksheets:
#>  Sheets: Sheet 1 
#>  Write order: 1