Dear List,
I am trying to solve a problem: I have approximately 100 Excel
spreadsheets each with approximately 4 sheet each that I would like to
download and import in R for analysis.
Unfortunately i realized (i also sent an email to the author or
xlsReadWrite() ) that the read.xls() doesn't allow to import the file in
R from internet.
Here it is the the code:
ciao<-read.xls("http://www.giustizia.it/statistiche/statistiche_dap/det/seriestoriche/corsi_proff.xls")
This doesn't work..
How would you solve the problem in an automated way? I would not like to
manually download each one, open it with excel and saving in in csv?
Thanks,
Francesco
Download and Import xls files in R
2 messages · Jacopo Anselmi, Domenico Vistocco
Jacopo Anselmi wrote:
Dear List,
I am trying to solve a problem: I have approximately 100 Excel
spreadsheets each with approximately 4 sheet each that I would like to
download and import in R for analysis.
Unfortunately i realized (i also sent an email to the author or
xlsReadWrite() ) that the read.xls() doesn't allow to import the file in
R from internet.
Here it is the the code:
ciao<-read.xls("http://www.giustizia.it/statistiche/statistiche_dap/det/seriestoriche/corsi_proff.xls")
Two candidate solutions: 1. use the read.xls function in the gdata package (where the file can be a url) 2. use the download.file function to download the file and then use the read.xls function in the xlsReadWrite function Ciao, domenico PS: please, check the setting of your mail program (I see three times the same mail)
This doesn't work.. How would you solve the problem in an automated way? I would not like to manually download each one, open it with excel and saving in in csv? Thanks, Francesco
______________________________________________ R-help at r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.