unhideSheet-methods | R Documentation |
Unhides the specified worksheets in a workbook
.
## S4 method for signature 'workbook,character' unhideSheet(object,sheet) ## S4 method for signature 'workbook,numeric' unhideSheet(object,sheet)
object |
The |
sheet |
The name or index of the sheet to unhide |
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
workbook
, hideSheet
,
isSheetHidden
, isSheetVeryHidden
,
isSheetVisible
## Not run: # Load workbook (create if not existing) wb <- loadWorkbook("unhideWorksheet.xlsx", create = TRUE) # Create sheet 'airquality' createSheet(wb, name = "airquality") # Write the built-in data set airquality to worksheet # 'airquality' writeWorksheet(wb, airquality, sheet = "airquality") # Create sheet 'CO2' createSheet(wb, name = "CO2") # Write the built-in data set CO2 to worksheet 'C02' writeWorksheet(wb, CO2, sheet = "CO2") # Hide sheet 'airquality' hideSheet(wb, sheet = "airquality") # Unhide sheet 'airquality' unhideSheet(wb, sheet = "airquality") # clean up file.remove("unhideWorksheet.xlsx") ## End(Not run)
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.