"Gabor Grothendieck" <[EMAIL PROTECTED]> wrote in news:[EMAIL PROTECTED]:
> On Thu, Mar 6, 2008 at 12:00 AM, David Winsemius > <[EMAIL PROTECTED]> wrote: >> Philipp Pagel <[EMAIL PROTECTED]> wrote in >> news:[EMAIL PROTECTED]: >> >> > On Wed, Mar 05, 2008 at 12:32:19PM +0100, Erika Frigo wrote: >> >> My file has not only more than a million values, but more than a >> >> million rows and moreless 30 columns (it is a productive dataset >> >> for cows), infact with read.table i'm not able to import it. >> >> It is an xls file. >> >> There is something very wrong here. Even the most recent versions >> of Excel cannot handle files with a million rows. Heck, they can't >> even handle files with one-tenth than number. In earlier versions >> the limit was on the order of 36K. > > Excel 2007 can handle over 1 million rows: > > http://office.microsoft.com/en-us/excel/HP100738491033.aspx#Worksheet > Workbook Yes. I was going to correct myself. I saw another posting that said they and Excel file with had 200,000 and just got back from checking the 2007version. 1,048,576 rows. The 2003 version's limit was 65,536 rows. -- David Winsemius ______________________________________________ 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.
