This low-level function returns cell data in a tibble with one row per cell.
This tibble has integer variables
column (referring to location
with the Google Sheet), an A1-style reference
loc, and a
list-column. The flagship function
what most users are looking for, rather than
read_sheet() is basically
range_read_cells() (this function), followed by
spread_sheet(), which looks after reshaping and column typing. But if you
really want raw cell data from the API,
range_read_cells() is for you!
range_read_cells( ss, sheet = NULL, range = NULL, skip = 0, n_max = Inf, cell_data = c("default", "full"), discard_empty = TRUE )
Something that identifies a Google Sheet: its file ID, a URL from
which we can recover the ID, an instance of
Sheet to read, in the sense of "worksheet" or "tab". You can identify a sheet by name, with a string, or by position, with a number. Ignored if the sheet is specified via
A cell range to read from. If
Minimum number of rows to skip before reading anything, be it
column names or data. Leading empty rows are automatically skipped, so this
is a lower bound. Ignored if
Maximum number of data rows to parse into the returned tibble.
Trailing empty rows are automatically skipped, so this is an upper bound on
the number of rows in the result. Ignored if
How much detail to get for each cell.
Whether to discard cells that have no data. Literally,
we check for an
A tibble with one row per cell in the