Skip to content

googlesheets4 1.0.0

Compare
Choose a tag to compare
@jennybc jennybc released this 21 Jul 19:23

User interface

The user interface has gotten more stylish, thanks to the cli package (https://cli.r-lib.org).

All informational messages, warnings, and errors are now emitted via cli, which uses rlang's condition functions under-the-hood.
googlesheets4 now throws errors with class "googlesheets4_error" (#12).

googlesheets4_quiet is a new option to suppress informational messages from googlesheets4 (#163).
Unless it's explicitly set to TRUE, the default is to message.

local_gs4_quiet() and with_gs4_quiet() are withr-style convenience helpers for setting googlesheets4_quiet = TRUE.

Other changes

The deprecated sheets_*() functions have now been removed, as promised in the warning they have been throwing for over a year.
No functionality has been removed, this is just the result of the function (re-)naming scheme adopted in googlesheets4 >= 0.2.0.
More details are in this developer documentation.

The na argument of read_sheet() has become more capable and more consistent with readr.
Specifically, na = character() (or the general lack of "" among the na strings) results in cells with no data appearing as the empty string "" within a character vector, as opposed to NA (#174).

Explicit NULLs are now written properly, i.e. as an empty cell (#203).

sheet_append() no longer touches any aspect of cell formatting other than numberFormat (#204).

gs4_example() and gs4_examples() now learn the example Sheet ids from a Google Sheet.
This should not change anything for users, but it means there is an API call the first time either of these functions is called.

Dependency changes

  • cli is new in Imports.

  • googlesheets4 Suggests testthat >= 3.0.0 and, specifically, uses third edition features.

R 3.4 is now the oldest version that is explicitly supported and tested, as per the tidyverse policy.