googlesheets (version 0.1.0)

gs_read_listfeed: Read data via the "list feed"

Description

Gets data via the "list feed", which assumes populated cells form a neat rectangle. The list feed consumes data row by row. The first row is assumed to hold variable or column names. The related function, gs_read_csv, also returns data from a rectangle of cells, but it is generally faster and more resilient to, e.g. empty rows, so use it if you can. However, you may need to use this function if you are dealing with an "old" Google Sheet, which gs_read_csv does not support). Consult the Google Sheets API documentation for more details about https://developers.google.com/google-apps/spreadsheets/data#work_with_list-based_feeds{the "list feed"}.

Usage

gs_read_listfeed(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

verbose

logical; do you want informative messages?

Value

• a tbl_df

See Also

Other data.consumption.functions: gs_read_cellfeed; gs_read_csv; gs_read; gs_reshape_cellfeed; gs_simplify_cellfeed

Examples

gap_ss <- gs_gap() # register the Gapminder example sheet
oceania_lf <- gs_read_listfeed(gap_ss, ws = "Oceania")
str(oceania_lf)
oceania_lf

Run the code above in your browser using DataCamp Workspace