On Tue, Jan 25, 2011 at 2:06 PM, cameron <raymond...@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 ______________________________________________ R-help@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.