Remove a worksheet from a workbook

Remove a worksheet from a Workbook object

Remove a worksheet from a workbook

removeWorksheet(wb, sheet)

Arguments

wb

A workbook object

sheet

A name or index of a worksheet

Author

Alexander Walker

Examples

## load a workbook
wb <- loadWorkbook(file = system.file("extdata", "loadExample.xlsx", package = "openxlsx"))

## Remove sheet 2
removeWorksheet(wb, 2)

## save the modified workbook
if (FALSE) { # \dontrun{
saveWorkbook(wb, "removeWorksheetExample.xlsx", overwrite = TRUE)
} # }