Data Engineering and BI courses are free this week!
ws_title,
row_extent, col_extent, and ... arguments to give the
worksheet a different title or extent or to populate it with some data. This
function calls the
gs_new(title = "my_sheet", ws_title = NULL, row_extent = NULL,
col_extent = NULL, ..., verbose = TRUE)gs_edit_cells in
order to populate the new worksheet with datagooglesheet objectgs_edit_cells) or by specifying row_extent
and col_extent directly. But not both ... although we won't stop you.
In that case, note that explicit worksheet sizing occurs before data
insertion. If data insertion triggers any worksheet resizing, that will
override any usage of row_extent or col_extent.gs_edit_cells for specifics on populating the new
sheet with some data and gs_upload for creating a new
spreadsheet by uploading a local file. Note that gs_upload is
likely much faster than using gs_new and/or
gs_edit_cells, so try both if speed is a concern.foo <- gs_new()
foo
gs_delete(foo)
foo <- gs_new("foo", ws_title = "numero uno", 4, 15)
foo
gs_delete(foo)
foo <- gs_new("foo", ws = "I know my ABCs", input = letters, trim = TRUE)
foo
gs_delete(foo)Run the code above in your browser using DataLab