Hi there great package :) I cannot enter more than 6990 rows into an Excel worksheet.
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