problem
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