Trying to read straight from the url using read_xlsx(url_from_vector_of_urls). It works if I use download.file first, then read in the result.
fileUrls <- c("https://docs.google.com/spreadsheet/pub?key=0AkBd6lyS3EmpdHo5S0J6ekhVOF9QaVhod05QSGV4T3c&output=xlsx",
"https://docs.google.com/spreadsheet/pub?key=phAwcNAVuyj2tPLxKvvnNPA&output=xlsx")
read_xlsx(fileUrls[1])
Error: path
does not exist: ‘https://docs.google.com/spreadsheet/pub?key=0AkBd6lyS3EmpdHo5S0J6ekhVOF9QaVhod05QSGV4T3c&output=xlsx’
Perhaps something to do with enquo ???
read_xlsx()
doesn't yet support reading directly from urls , see this github issue
2 Likes
cderv
3
For google spreadsheets, you could be interested in
This will allow you to read the spreadsheet through the googlesheet API.
1 Like
system
Closed
4
This topic was automatically closed 21 days after the last reply. New replies are no longer allowed.
If you have a query related to it or one of the replies, start a new topic and refer back with a link.