R help - Jan 2011 - Importing xls from a http://

I know a lot of people asked similar questions like this.  I have tried using 

read.xls ()
Error in .Call("ReadXls", file, colNames, sheet, type, from, rowNames,
:
  Incorrect number of arguments (11), expecting 10 for ReadXls

read.table or read.csv (Wrong table format)

odbcConnectExcel have problem with the URL 

I want to import this excel file
(http://www.econ.yale.edu/~shiller/data/ie_data.xls) from row 8 in Data
sheet.

Thanks
Cameron
-- 
View this message in context:
http://r.789695.n4.nabble.com/Importing-xls-from-a-http-tp3236800p3236800.html
Sent from the R help mailing list archive at Nabble.com.

On Tue, Jan 25, 2011 at 2:06 PM, cameron <raymond.fu at invesco.com>
wrote:
>
> I know a lot of people asked similar questions like this. ?I have tried
using
>
> read.xls ()
> Error in .Call("ReadXls", file, colNames, sheet, type, from,
rowNames, ?:
> ?Incorrect number of arguments (11), expecting 10 for ReadXls
>
> read.table or read.csv (Wrong table format)
>
> odbcConnectExcel have problem with the URL
>
> I want to import this excel file
> (http://www.econ.yale.edu/~shiller/data/ie_data.xls) from row 8 in Data
> sheet.
How to import a spreadsheet from the internet was asked less than 24
hours ago on this list.  See:
http://rwiki.sciviews.org/doku.php?id=tips:data-io:ms_windows

e.g.

library(gdata)
URL <- "http://www.econ.yale.edu/~shiller/data/ie_data.xls"
DF <- read.xls(URL, pattern = "Fraction")


-- 
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com