sheetVisibility: Get/set worksheet visible state

Description Usage Arguments Value Examples

Description

Get and set worksheet visible state

Usage

1
2
3

Arguments

wb

A workbook object

value

a logical/character vector the same length as sheetVisibility(wb)

Value

Character vector of worksheet names.

Vector of "hidden", "visible", "veryHidden"

Examples

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
wb <- createWorkbook()
addWorksheet(wb, sheetName = "S1", visible = FALSE)
addWorksheet(wb, sheetName = "S2", visible = TRUE)
addWorksheet(wb, sheetName = "S3", visible = FALSE)

sheetVisibility(wb)
sheetVisibility(wb)[1] <- TRUE ## show sheet 1
sheetVisibility(wb)[2] <- FALSE ## hide sheet 2
sheetVisibility(wb)[3] <- "hidden" ## hide sheet 3
sheetVisibility(wb)[3] <- "veryHidden" ## hide sheet 3 from UI

awalker89/openxlsx documentation built on May 11, 2019, 4:09 p.m.