gsheet2text: Download Google sheet as text.
In gsheet: Download Google Sheets Using Just the URL
Description
Usage
Arguments
Details
See Also
Examples
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 April 14, 2020, 6:19 p.m.
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Description Usage Arguments Details See Also Examples
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. |
sheetid |
the id of the sheet to download from. (Default |
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)
|
R Package Documentation
Browse R Packages
We want your feedback!
Note that we can't provide technical support on individual packages. You should contact the package authors for that.
Embedding an R snippet on your website
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.