unhideSheet-methods {XLConnect} | R Documentation |
Unhiding worksheets in a workbook
Description
Unhides the specified worksheets in a workbook
.
Usage
## S4 method for signature 'workbook,character'
unhideSheet(object,sheet)
## S4 method for signature 'workbook,numeric'
unhideSheet(object,sheet)
Arguments
object |
The |
sheet |
The name or index of the sheet to unhide |
Author(s)
Martin Studer
Mirai Solutions GmbH https://mirai-solutions.ch
See Also
workbook
, hideSheet
,
isSheetHidden
, isSheetVeryHidden
,
isSheetVisible
Examples
## 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)
[Package XLConnect version 1.0.10 Index]