googlesheets4 (development version) Unreleased

Write Sheets

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.

Other new functions and arguments

There is a new family of sheets_sheet_*() functions that operate on the (work)sheets inside an existing (spread)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).

Renamed functions and classes

  • 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.

Printing a Sheet ID

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.

Bug fixes

  • read_sheet() passes its na argument down to the helpers that parse cells, so that na actually has the documented effect (#73).

googlesheets4 0.1.1 2020-03-21

  • Patch release to modify a test fixture, to be compatible with tibble v3.0. Related to tibble’s increased type strictness.

googlesheets4 0.1.0 2019-11-04

  • Added a file to track changes to the package.