Skip to contents

Set worksheet names for a workbook

Source: R/class-workbook-wrappers.R
wb_set_sheet_names.Rd

Sets the worksheet names for a wbWorkbook object.

Usage

wb_set_sheet_names(wb, old = NULL, new)

Arguments

wb

A wbWorkbook object

old

The name (or index) of the old sheet name. If NULL will assume all worksheets are to be renamed.

new

The name of the new sheet

Value

The wbWorkbook object

Details

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.