Re: [R] problem

From: David Winsemius <dwinsemius_at_comcast.net>
Date: Thu, 06 Mar 2008 05:31:54 +0000 (UTC)

"Gabor Grothendieck" <ggrothendieck_at_gmail.com> wrote in news:971536df0803052116q6a91bd95ja50ed541330d8ff1_at_mail.gmail.com:

> 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#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_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:34:34 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:20 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