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#WorksheetWorkbook ______________________________________________ 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.
