Hello POI Team, We have large data fetched from database. Around 10000 rows and 33 columns per row. Also, we do not want to increase the heap size of jvm. Can you suggest something on lines of writingthe rows incrementally into Excel sheet. I mean, say every 1000 records I write I close the output stream object. Again reinitialize the HSSFWorksheet object and open the same Excel file and write next 1000 records. This way we can avoid the HSSFWorksheet object size to bulge out of bounds. Please advise. Thanks, Saurabh Singh Morgan Stanley | Technology D4 Sector 59 | Uttar Pradesh Noida, 201307 Phone: +91 12 0407-5531 [EMAIL PROTECTED] --------------------------------------------------------
NOTICE: If received in error, please destroy and notify sender. Sender does not intend to waive confidentiality or privilege. Use of this email is prohibited when received in error.
