sheet_remove: Remove a sheet
In officer: Manipulation of Microsoft Word and PowerPoint Documents
sheet_remove R Documentation
Remove a sheet
Description
Remove a sheet from an xlsx workbook, deleting the
worksheet XML, its relationship file and the content-type override.
Usage
sheet_remove(x, sheet)
Arguments
x
rxlsx object
sheet
name of the sheet to remove
Value
the rxlsx object (invisibly)
Examples
wb <- read_xlsx()
wb <- add_sheet(wb, "kept")
default_name <- sheet_names(wb)[1]
wb <- sheet_remove(wb, sheet = default_name)
print(wb, target = tempfile(fileext = ".xlsx"))
officer documentation built on April 24, 2026, 5:06 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
| sheet_remove | R Documentation |
Remove a sheet
Description
Remove a sheet from an xlsx workbook, deleting the worksheet XML, its relationship file and the content-type override.
Usage
sheet_remove(x, sheet)
Arguments
x |
rxlsx object |
sheet |
name of the sheet to remove |
Value
the rxlsx object (invisibly)
Examples
wb <- read_xlsx()
wb <- add_sheet(wb, "kept")
default_name <- sheet_names(wb)[1]
wb <- sheet_remove(wb, sheet = default_name)
print(wb, target = tempfile(fileext = ".xlsx"))
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.