Remove a worksheet from a Workbook object
Remove a worksheet from a workbook
removeWorksheet(wb, sheet)
wb | A workbook object |
---|---|
sheet | A name or index of a worksheet |
Alexander Walker
## 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) { saveWorkbook(wb, "removeWorksheetExample.xlsx", overwrite = TRUE) }