Need help in writing very large spreadsheet containing cell comments through POI.
Out of memory (Heap Size 1 GB) o When writing data of around 10,00,000 into excel, system is throwing error. Following changes were made for mitigation • Tried to call System.gc • Making some of the objects “NULL” ,if not required in scope. • Uses SXSSF Workbook (with help of it we can specify number rows which can be accessed) • Fetched data from database in chunks. Size of Workbook object o Is it possible to keep only working sheet in memory, to reduce the size of workbook in JVM. o How to dispose of the workbook and its temp files Comments size in a cell o On Analysis it was identified, all the comments in the cell are using tremendous memory, is there any workaround available ? -- View this message in context: http://apache-poi.1045710.n5.nabble.com/Issue-in-writing-very-large-spreadsheet-with-cell-comments-using-SXSSF-tp5717589.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]
