Get and set worksheet visible state
Usage
wb_get_sheet_visibility(wb)
wb_set_sheet_visibility(wb, sheet = current_sheet(), value)
Arguments
- wb
A
wbWorkbook
object- sheet
Worksheet identifier
- value
a logical/character vector the same length as sheet
Examples
wb <- wb_workbook()
wb$add_worksheet(sheet = "S1", visible = FALSE)
wb$add_worksheet(sheet = "S2", visible = TRUE)
wb$add_worksheet(sheet = "S3", visible = FALSE)
wb$get_sheet_visibility()
#> [1] "hidden" "visible" "hidden"
wb$set_sheet_visibility(1, TRUE) ## show sheet 1
wb$set_sheet_visibility(2, FALSE) ## hide sheet 2
wb$set_sheet_visibility(3, "hidden") ## hide sheet 3
wb$set_sheet_visibility(3, "veryHidden") ## hide sheet 3 from UI