openxlsx (version 1.0.3)

removeWorksheet: Remove a worksheet from a workbook

Description

Remove a worksheet from a workbook

Usage

removeWorksheet(wb, sheet)

Arguments

wb

A workbook object

sheet

A name or index of a worksheet

Examples

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

## Remove sheet 2
removeWorksheet(wb, 2)

## save the modified workbook
saveWorkbook(wb, "removeWorksheetExample.xlsx", overwrite = TRUE)