[R] Download and Import xls files in R
Jacopo Anselmi
jacopo.anselmi at gmail.com
Sat Mar 7 06:22:50 CET 2009
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
More information about the R-help
mailing list