Get worksheet visible state.

DEPRECATED - Use function 'sheetVisibility()

sheetVisible(wb)

sheetVisible(wb) <- value

Arguments

wb

A workbook object

value

a logical vector the same length as sheetVisible(wb)

Value

Character vector of worksheet names. TRUE if sheet is visible, FALSE if sheet is hidden

Author

Alexander Walker

Examples

wb <- createWorkbook()
addWorksheet(wb, sheetName = "S1", visible = FALSE)
addWorksheet(wb, sheetName = "S2", visible = TRUE)
addWorksheet(wb, sheetName = "S3", visible = FALSE)

sheetVisible(wb)
#> Warning: This function is deprecated. Use function 'sheetVisibility()'
#> [1] FALSE  TRUE FALSE
sheetVisible(wb)[1] <- TRUE ## show sheet 1
#> Warning: This function is deprecated. Use function 'sheetVisibility()'
#> Warning: This function is deprecated. Use function 'sheetVisibility()'
sheetVisible(wb)[2] <- FALSE ## hide sheet 2
#> Warning: This function is deprecated. Use function 'sheetVisibility()'
#> Warning: This function is deprecated. Use function 'sheetVisibility()'