[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