isSheetHidden-methods | R Documentation |
Checks if the specified worksheets are hidden (but not very hidden) in a workbook
.
## S4 method for signature 'workbook,character' isSheetHidden(object,sheet) ## S4 method for signature 'workbook,numeric' isSheetHidden(object,sheet)
object |
The |
sheet |
The name or index of the sheet to check |
Returns TRUE
if the specified sheet
is hidden (not visible
but also not very hidden), otherwise FALSE
. sheet
is
vectorized such that multiple worksheets can be queried with one method
call. An exception is thrown if the specified sheet
does not exist.
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
, hideSheet
, unhideSheet
,
isSheetVeryHidden
, isSheetVisible
## Not run: # Load workbook (create if not existing) wb <- loadWorkbook("isSheetHidden.xlsx", create = TRUE) # Write a couple of built-in data.frame's into sheets # with corresponding name for(obj in c("CO2", "airquality", "swiss")) { createSheet(wb, name = obj) writeWorksheet(wb, get(obj), sheet = obj) } # Hide sheet 'airquality' hideSheet(wb, sheet = "airquality") # Check if sheet 'airquality' is hidden; # this should obviously return TRUE isSheetHidden(wb, "airquality") # Check if sheet 'swiss' is hidden; # this should obviously return FALSE isSheetHidden(wb, "swiss") # clean up file.remove("isSheetHidden.xlsx") ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.