[R] Download and Import xls files in R

Francesco Petrarca francesco.petrarca09 at gmail.com
Sat Mar 7 04:04:07 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:


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?



More information about the R-help mailing list