These functions are ready for use but are still considered experimental and may see more refinements to their interface and capabilities:
sheets_create()is a new function to create a new Sheet and, optionally, write one or more data frames into it (#61).
sheets_write()(also available as
write_sheet()) is a new function to write a data frame into a new or existing (work)sheet, inside a new or existing (spread)Sheet.
sheets_append()adds rows to the data in an existing sheet.
sheets_edit()writes to a range.
sheets_flood()“floods” all cells in a range with the same content.
sheets_clear()is a wrapper for the special case of clearing cell values.
There is a new family of
sheets_sheet_*() functions that operate on the (work)sheets inside an existing (spread)Sheet:
sheets_sheet_properties()returns a tibble of metadata with one row per sheet.
sheets_sheet_names()returns sheet names.
sheets_sheet_add()adds one or more sheets.
sheets_sheet_delete()deletes one or more sheets.
sheets_sheet_resize()changes the number of rows or columns in a sheet.
sheets_speedread() provides a quick-and-dirty for reading a Sheet using its “export=csv” URL.
sheets_cells() gains two new arguments that make it possible to get more data on more cells. By default, we get only the fields needed to parse cells that contain values. But
sheets_cells(cell_data = "full", discard_empty = FALSE) is now available if you want full cell data, including formatting, even for cells that have no value (#4).
sheets_sheets() is now
sheets_sheet_names(), in order to fit into a coherent family of
sheets_sheet_*() functions that deal with (work)sheets.
sheets_sheets() still exists but will be removed rather quickly since googlesheets4 is so new.
The S3 class
sheets_Spreadsheet is renamed to
googlesheets4_spreadsheet, a consequence of rationalizing all internal and external classes.
googlesheets4_spreadsheet is the class that holds metadata for a Sheet and it is connected to the API’s
Spreadsheet schema. The return value of
sheets_get() has this class.
The print method for
sheets_id objects now attempts to reveal the current Sheet metadata available via
sheets_get(). The means that printing can lead to an attempt to initiate auth, unless
sheets_deauth() has been called. However,
sheets_id printing should never lead to an actual error condition, although it may reveal information from caught errors.