Resize a worksheet
Set the number of rows and columns of a worksheet. We use this function internally during cell updates, if the data would exceed the current worksheet extent, and to trim worksheet down to fit the data exactly. Is it possible a user might want to use this directly?
gs_ws_resize(ss, ws = 1, row_extent = NULL, col_extent = NULL, verbose = TRUE)
ss |
a registered Google spreadsheet, i.e. a |
ws |
positive integer or character string specifying index or title, respectively, of the worksheet |
row_extent |
integer for new row extent; if unspecified, the Google Sheets default is 1000 |
col_extent |
integer for new column extent; if unspecified, the Google Sheets default is 26 |
verbose |
logical; do you want informative messages? |
Setting rows and columns to less than the current worksheet dimensions will delete contents without warning!
## Not run:
yo <- gs_new("yo")
yo <- gs_edit_cells(yo, input = head(iris), trim = TRUE)
gs_read_csv(yo)
yo <- gs_ws_resize(yo, ws = "Sheet1", row_extent = 5, col_extent = 4)
gs_read_csv(yo)
yo <- gs_ws_resize(yo, ws = 1, row_extent = 3, col_extent = 3)
gs_read_csv(yo)
yo <- gs_ws_resize(yo, row_extent = 2, col_extent = 2)
gs_read_csv(yo)
gs_delete(yo)
## End(Not run)Please choose more modern alternatives, such as Google Chrome or Mozilla Firefox.