R googlesheets4 sheet_resize 更改(工作)表的大小

sheet_resize(ss, sheet = NULL, nrow = NULL, ncol = NULL, exact = FALSE)

製作 UpdateSheetPropertiesRequest ：

• https://developers.google.com/sheets/api/reference/rest/v4/spreadsheets/request#UpdateSheetPropertiesRequest

其他工作表函數：sheet_add() , sheet_append() , sheet_copy() , sheet_delete() , sheet_properties() , sheet_relocate() , sheet_rename() , sheet_write()

# create a Sheet with the default initial worksheet
(ss <- gs4_create("sheet-resize-demo"))
#> ✔ Creating new Sheet: sheet-resize-demo.
#> 
#> ── <googlesheets4_spreadsheet> ───────────────────────────────────────────
#> Spreadsheet name: sheet-resize-demo                           
#>               ID: 12w86MHhvrUq6GoVmVNe1evzZlYHe3xCJm9K37giLJtI
#>           Locale: en_US                                       
#>        Time zone: Etc/GMT                                     
#>      # of sheets: 1                                           
#> 
#> ── <sheets> ──────────────────────────────────────────────────────────────
#> (Sheet name): (Nominal extent in rows x columns)
#>       Sheet1: 1000 x 26

# see (work)sheet dims
sheet_properties(ss)
#> # A tibble: 1 × 8
#>   name   index    id type  visible grid_rows grid_columns data  
#>   <chr>  <int> <int> <chr> <lgl>       <int>        <int> <list>
#> 1 Sheet1     0     0 GRID  TRUE         1000           26 <NULL>

# no resize occurs
sheet_resize(ss, nrow = 2, ncol = 6)
#> ✔ Resizing sheet Sheet1 in sheet-resize-demo.
#> ℹ No need to change existing dims (1000 x 26).

# reduce sheet size
sheet_resize(ss, nrow = 5, ncol = 7, exact = TRUE)
#> ✔ Resizing sheet Sheet1 in sheet-resize-demo.
#> ✔ Changing dims: (1000 x 26) --> (5 x 7).

# add rows
sheet_resize(ss, nrow = 7)
#> ✔ Resizing sheet Sheet1 in sheet-resize-demo.
#> ✔ Changing dims: (5 x 7) --> (7 x 7).

# add columns
sheet_resize(ss, ncol = 10)
#> ✔ Resizing sheet Sheet1 in sheet-resize-demo.
#> ✔ Changing dims: (7 x 7) --> (7 x 10).

# add rows and columns
sheet_resize(ss, nrow = 9, ncol = 12)
#> ✔ Resizing sheet Sheet1 in sheet-resize-demo.
#> ✔ Changing dims: (7 x 10) --> (9 x 12).

# re-inspect (work)sheet dims
sheet_properties(ss)
#> # A tibble: 1 × 8
#>   name   index    id type  visible grid_rows grid_columns data  
#>   <chr>  <int> <int> <chr> <lgl>       <int>        <int> <list>
#> 1 Sheet1     0     0 GRID  TRUE            9           12 <NULL>

# clean up
gs4_find("sheet-resize-demo") %>%
  googledrive::drive_trash()
#> File trashed:
#> • sheet-resize-demo <id: 12w86MHhvrUq6GoVmVNe1evzZlYHe3xCJm9K37giLJtI>