I am experiencing this issue. I am creating an HSSFWorkbook with an excel document stream from a file, but it takes more than an hour for the HSSFWorkbook to be created, and it crashes before it can finish due to java heap space running out of memory!
The file is 24 megabytes, and simply consists of thousands of rows with whole numbers in each cell. There are tens of thousands of rows. Is POI really slow and inefficient? Is there a way to fix this problem? One would think that an HSSFWorkbook, even with the number of rows and cells I am dealing with, could be instantiated much faster than this! Please help if you know what the problem is. -- View this message in context: http://www.nabble.com/Urgent%3A%3APOI-is-too-slow-for-generating-excel-for-more-than-60000-rows-tp17646122p23655642.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
