Try this:
> library(gdata)
> ciao<-read.xls(pattern = "TOTALE",
"http://www.giustizia.it/statistiche/statistiche_dap/det/seriestoriche/corsi_proff.xls")
Downloading...
trying URL
'http://www.giustizia.it/statistiche/statistiche_dap/det/seriestoriche/corsi_proff.xls'
Content type 'application/vnd.ms-excel' length 33280 bytes (32 Kb)
opened URL
downloaded 32 Kb
Done.
Converting xls file to csv file... Done.
Searching for lines containing pattern TOTALE ... Done.
Reading csv file... Done.> head(ciao)
X X.1 UOMINI DONNE TOTALE X.2 UOMINI.1 DONNE.1 TOTALE.1 UOMINI.2
1 I sem. 91 185 nd nd 1,926 nd nd nd nd nd
2 II sem. 91 275 nd nd 2,470 89 nd nd nd nd
3 I sem.92 230 3,265 432 3,697 133 1,524 200 1,724 543
4 II sem.92 205 2,581 417 2,998 83 864 115 979 413
5 I sem.93 241 3,165 439 3,604 105 1,171 222 1,393 661
6 II sem.93 256 2,844 395 3,239 94 986 102 1,088 516
DONNE.2 TOTALE.2
1 nd nd
2 nd nd
3 88 631
4 66 479
5 91 752
6 79 595>
On Fri, Mar 6, 2009 at 10:04 PM, Francesco Petrarca
<francesco.petrarca09 at gmail.com> 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")
>
> 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.
>