This function reads all data from a worksheet and returns it as a
tbl_df or data.frame. Don't be spooked by the "csv" thing --
the data is NOT actually written to file during this process. Data is read
from the "maximal data rectangle", i.e. the rectangle spanned by the maximal
row and column extent of the data. Empty cells within this rectangle will be
assigned NA. This is the fastest method of data consumption, so use it as
long as you can tolerate the lack of control re: which cells are being read.
Usage
gs_read_csv(ss, ws = 1, ..., verbose = TRUE)
Arguments
ss
a registered Google spreadsheet, i.e. a googlesheet
object
ws
positive integer or character string specifying index or title,
respectively, of the worksheet
...
Further arguments to be passed to the csv parser. This is
currently read.csv, but expect a switch to
readr::read_csv in the not-too-distant future! Note that by default
verbose
logical; do you want informative messages?
Value
a tbl_df
Details
How does this compare to consumption via the list feed, implemented by
gs_read_listfeed? First, gs_read_csv is much, much
faster. Second, the first row, potentially containing column or variable
names, is NOT transformed/mangled, as it is via the list feed. Finally,
consumption via the exportcsv link is more tolerant of data that does
not form a perfect, neat rectangle, e.g. the read does NOT stop upon
encountering an empty row.