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? 

OK, here is the error message :




Exception occurred during event dispatching:




java.lang.OutOfMemoryError




	<<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.

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. 

Thanks, that helped