gsheet2text: Download Google sheet as text.

Description Usage Arguments Details See Also Examples

View source: R/gsheet2text.R

Description

Downloads a Google sheet as text, using just the url. The Google sheet must have 'share by link' turned on.

Usage

1
gsheet2text(url, format = "csv", sheetid = NULL)

Arguments

url

the google sheet url

format

controls the column separator used. csv or tsv

sheetid

the id of the sheet to download from. (Default NULL, downloads the first sheet)

Details

sheetid is the index of the sheet to be downloaded. If you use the direct sheet URL, rather than the share by link, this will automatically be extracted. Otherwise, the first sheet will be downloaded by default.

See Also

gsheet2text to download as a table

Examples

1
2
3
url <- 'docs.google.com/spreadsheets/d/1I9mJsS5QnXF2TNNntTy-HrcdHmIF9wJ8ONYvEJTXSNo'
a <- gsheet2text(url)
b <- read.csv(text=a)

gsheet documentation built on May 29, 2017, 8:44 p.m.

Search within the gsheet package
Search all R packages, documentation and source code