sheet_names-wb: Get / Set worksheet names for a workbook

In openxlsx2: Read, Write and Edit 'xlsx' Files

Get / Set worksheet names for a workbook

Description

Gets / Sets the worksheet names for a wbWorkbook object.

Usage

wb_set_sheet_names(wb, old = NULL, new)

wb_get_sheet_names(wb, escape = FALSE)

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
escape	Should the xml special characters be escaped?

Details

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.

Value

• 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.

openxlsx2 documentation built on April 3, 2025, 8:40 p.m.