Bug 15305 - Maximum rows in excel worksheet
Summary: Maximum rows in excel worksheet
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: PC All
: P3 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2002-12-12 11:04 UTC by Fabio
Modified: 2005-03-20 17:06 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Fabio 2002-12-12 11:04:07 UTC
Hi there great package :) 

I cannot enter more than 6990 rows into an Excel worksheet.
Comment 1 Avik Sengupta 2002-12-12 12:53:31 UTC
thanks for the compliment, but maybe you should provide more details, since many
people use POI to create files with many more rows than 7000. So what exactly is
your problem? 
Comment 2 Fabio 2002-12-12 13:06:12 UTC
OK, here is the error message :

Exception occurred during event dispatching:


	<<no stack trace available>>

All I'm doing is populating 7000 rows :

for(short i=1; i <= 7000; i++) {

  row = sheet.createRow( rowNum++ );

  for(short j=0; j < iTotalColumns; j++ ) {

    row.createCell((short) j).

    setCellValue("" + jdbTable1.getValueAt(rowNum, j) + "" );



Hope this helps, thanks for the reply.
Comment 3 Avik Sengupta 2002-12-12 13:20:47 UTC
provide more memory to your jvm. try giving the params -mx128M or -mx256M to
your jvm (for using 128 or 265 megs respectively).  With large files, POI does
need a significant amount of memory. 
Comment 4 Fabio 2002-12-12 13:26:38 UTC
Thanks, that helped