Re: [R] problem

From: Gabor Grothendieck <ggrothendieck_at_gmail.com>
Date: Thu, 06 Mar 2008 00:16:59 -0500

On Thu, Mar 6, 2008 at 12:00 AM, David Winsemius <dwinsemius_at_comcast.net> wrote:
> Philipp Pagel <p.pagel@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



R-help_at_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. Received on Thu 06 Mar 2008 - 05:19:28 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Thu 06 Mar 2008 - 06:30:19 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.

list of date sections of archive