Using read_xlsx

tidyverse
#1

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 ???

#2

read_xlsx() doesn't yet support reading directly from urls , see this github issue

2 Likes
#3

For google spreadsheets, you could be interested in

This will allow you to read the spreadsheet through the googlesheet API.

1 Like
#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.