Rename a worksheet within a spreadsheet
Give a worksheet a new title that does not duplicate the title of any existing worksheet within the spreadsheet.
gs_ws_rename(ss, from = 1, to, verbose = TRUE)
ss |
a registered Google spreadsheet, i.e. a |
from |
positive integer or character string specifying index or title, respectively, of the worksheet |
to |
character string for new title of worksheet |
verbose |
logical; do you want informative messages? |
a googlesheet object
Since the edit link is used in the PUT request, the version path in the url changes everytime changes are made to the worksheet, hence consecutive function calls using the same edit link from the same sheet object without 'refreshing' it by re-registering results in a HTTP 409 Conflict.
## Not run: gap_ss <- gs_copy(gs_gap(), to = "gap_copy") gs_ws_ls(gap_ss) gap_ss <- gs_ws_rename(gap_ss, from = "Oceania", to = "ANZ") gs_ws_ls(gap_ss) gap_ss <- gs_ws_rename(gap_ss, from = 1, to = "I am the first sheet!") gs_ws_ls(gap_ss) gs_delete(gap_ss) ## End(Not run)
Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.