[R] Download and Import xls files in R

[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.
>
>