Hi, I make sure that the cell styles that I register are unique and I wouldn't expect to have more than a few hundred at most. But even if the sheet contains thousands of different colors/font combinations that isn't likely to be the reason that you run out of memory. You can however run into trouble if you use merged regions (Sheet.addMergedRegion()) because these are kept in memory and the numbers can be quite large. If for example you have two cells that are merged per row then you will have as many entries as rows. This issue could be fixed by writing the file containing the merged regions in streaming manner the same way we are writing the data file. If this isn't the issue then I suggest to analyze the heap (e.g. use jhat) to see what classes are at the top of the heap histogram. Regards, Alex
-- View this message in context: http://apache-poi.1045710.n5.nabble.com/SXSSF-Writing-Memory-issues-tp5161879p5166819.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]
