unhideSheet-methods

0th

Percentile

Unhiding worksheets in a workbook

Unhides the specified worksheets in a '>workbook.

Keywords
methods, utilities
Usage
# S4 method for workbook,character
unhideSheet(object,sheet)
# S4 method for workbook,numeric
unhideSheet(object,sheet)
Arguments
object

The '>workbook to use

sheet

The name or index of the sheet to unhide

See Also

'>workbook, hideSheet, isSheetHidden, isSheetVeryHidden, isSheetVisible

Aliases
  • unhideSheet
  • unhideSheet-methods
  • unhideSheet,workbook,character-method
  • unhideSheet,workbook,numeric-method
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")
# }
Documentation reproduced from package XLConnect, version 0.2-15, License: GPL-3

Community examples

Looks like there are no examples yet.