Rename a worksheet
Rename a worksheet
renameWorksheet(wb, sheet, newName)
wb |
A Workbook object containing a worksheet |
sheet |
The name or index of the worksheet to rename |
newName |
The new name of the worksheet. No longer than 31 chars. |
DEPRECATED. Use names
Alexander Walker
## Create a new workbook wb <- createWorkbook("CREATOR") ## Add 3 worksheets addWorksheet(wb, "Worksheet Name") addWorksheet(wb, "This is worksheet 2") addWorksheet(wb, "Not the best name") #' ## rename all worksheets names(wb) <- c("A", "B", "C") ## Rename worksheet 1 & 3 renameWorksheet(wb, 1, "New name for sheet 1") names(wb)[[1]] <- "New name for sheet 1" names(wb)[[3]] <- "A better name" ## Save workbook ## Not run: saveWorkbook(wb, "renameWorksheetExample.xlsx", overwrite = TRUE) ## End(Not run)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.