Gets / Sets the worksheet names for a wbWorkbook object.
wb_set_sheet_names(wb, old = NULL, new)wb_get_sheet_names(wb)
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
This only changes the sheet name as shown in spreadsheet software and will not alter it anywhere else. Not in formulas, chart references, named regions, pivot tables or anywhere else.