Learn R Programming

openxlsx (version 4.2.7.1)

activeSheet: Get/set active sheet of the workbook

Description

Get and set active sheet of the workbook

Usage

activeSheet(wb)

activeSheet(wb) <- value

Value

return the active sheet of the workbook

Arguments

wb

A workbook object

value

index of the active sheet or name of the active sheet

Author

Philipp Schauberger

Examples

Run this code

wb <- createWorkbook()
addWorksheet(wb, sheetName = "S1")
addWorksheet(wb, sheetName = "S2")
addWorksheet(wb, sheetName = "S3")

activeSheet(wb) # default value is the first sheet active
activeSheet(wb) <- 1 ## active sheet S1
activeSheet(wb)
activeSheet(wb) <- "S2" ## active sheet S2
activeSheet(wb)

Run the code above in your browser using DataLab