Rename a (work)sheet
Changes the name of a (work)sheet.
sheet_rename(ss, sheet = NULL, new_name)
ss |
Something that identifies a Google Sheet: its file ID, a URL from
which we can recover the ID, an instance of |
sheet |
Sheet to rename, in the sense of "worksheet" or "tab". You can identify a sheet by name, with a string, or by position, with a number. Defaults to the first visible sheet. |
new_name |
New name of the sheet, as a string. This is required. |
The input ss, as an instance of sheets_id
Makes an UpdateSheetPropertiesRequest:
Other worksheet functions:
sheet_add(),
sheet_append(),
sheet_copy(),
sheet_delete(),
sheet_properties(),
sheet_relocate(),
sheet_resize(),
sheet_write()
if (gs4_has_token()) {
ss <- gs4_create(
"sheet-rename-demo",
sheets = list(iris = head(iris), chickwts = head(chickwts))
)
sheet_names(ss)
ss %>%
sheet_rename(1, new_name = "flowers") %>%
sheet_rename("chickwts", new_name = "poultry")
# clean up
gs4_find("sheet-rename-demo") %>%
googledrive::drive_trash()
}Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.