Gets / Sets the worksheet names for a wbWorkbook object.
wb_set_sheet_names(wb, old = NULL, new)wb_get_sheet_names(wb, escape = FALSE)
set_
: The wbWorkbook
object.
get_
: A named character vector of sheet names in order. The
names represent the original value of the worksheet prior to any character
substitutions.
A wbWorkbook object
The name (or index) of the old sheet name. If NULL
will assume
all worksheets are to be renamed.
The name of the new sheet
Should the xml special characters be escaped?
This only changes the sheet name as shown in spreadsheet software and will not alter it elsewhere. Not in formulas, chart references, named regions, pivot tables or anywhere else.