[R] problem

[Gabor Grothendieck]

On Thu, Mar 6, 2008 at 12:00 AM, David Winsemius <dwinsemius at comcast.net> wrote:
> Philipp Pagel <p.pagel at wzw.tum.de> wrote in
> news:20080305120637.GA8181 at localhost:
>
> > 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