[R] Importing xls from a http://

Gabor Grothendieck ggrothendieck at gmail.com
Tue Jan 25 20:55:27 CET 2011

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:


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

More information about the R-help mailing list