I have stored MS-Excel data in a private bitbucket repository. Can anyone advise how I can read the .xlsx file into R using the readxl package?
In the case of a .csv file here is an example that works with github:
require(RCurl)
campnet.attr <- read.csv(text = getURL("https://raw.githubusercontent.com/kateto/Network_Analysis_R_Examples/master/Sample%20Data/campnet-attr.csv"), header = T, as.is = T)
I use readxl on my local file system as follows:
dat <- read_excel("~/ownCloud/surveydata_case_1.xlsx", sheet = 1)
Please advise.
