In JExcel, we are Writing Cell by Cell. Excel Writing will start, (JDBC) after While(rs.next()) loop. JExcel will take more HEAP Memory. For Example , You are taking 2 1/2 Lakshs Records from resultset, then JExcel will place this records in HEAP Memory during cell by Cell Writing. Whenever this loop is Completed after that only it will create Excel File in Client Side. I checked another Pakage POI API from Apache Software. This API also doing the Same Logic. We can Achive Sheet by Sheet...
Read Full Story