googlesheets (version 0.1.0)

gs_download: Download a spreadsheet

Description

Export a Google Sheet as a .csv, .pdf, or .xlsx file. You can download a sheet that you own or a sheet owned by a third party that has been made accessible via the sharing dialog options. You can download the entire spreadsheet (.pdf and .xlsx formats) or a single worksheet. This function calls the https://developers.google.com/drive/v2/reference/{Google Drive API}. Note that the current implementation of this function absolutely requires authorization.

Usage

gs_download(from, ws = NULL, to = "my_sheet.xlsx", overwrite = FALSE,
  verbose = TRUE)

Arguments

from

a registered Google spreadsheet, i.e. a googlesheet object

ws

positive integer or character string specifying index or title, respectively, of the worksheet

to

path to write file; file extension must be one of .csv, .pdf, or .xlsx, which dictates the export format

overwrite

logical, indicating whether to overwrite an existing local file

verbose

logical; do you want informative messages?

Details

If the worksheet is unspecified, i.e. if ws = NULL, then the entire spreadsheet will be exported (.pdf and xlsx formats) or the first worksheet will be exported (.csv format)

Examples

gs_download(gs_gap(), to = "gapminder.xlsx")
file.remove("gapminder.xlsx")