Learn R Programming

openxlsx (version 2.0.15)

sheets: Returns names of worksheets.

Description

Returns names of worksheets.

Usage

sheets(wb)

Arguments

wb
A workbook object

Value

  • Name of worksheet(s) for a given index

Details

DEPRECATED. Use names

See Also

names to rename a worksheet in a Workbook

Examples

Run this code
## Create a new workbook
wb <- createWorkbook()

## Add some worksheets
addWorksheet(wb, "Worksheet Name")
addWorksheet(wb, "This is worksheet 2")
addWorksheet(wb, "The third worksheet")

## Return names of sheets, can not be used for assignment.
names(wb)
# openXL(wb)

names(wb) <- c("A", "B", "C")
names(wb)
# openXL(wb)

Run the code above in your browser using DataLab