[R] problem

[David Winsemius]

"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