Hi,
I am using aspose.Cells version 1.9.5.
While generating a large excel report (arround 10000 rows) I am getting OutOfMemory exception.
Looking at the profiler, I see that a large amount of memory is taken by aspose items:
Aspose.cells.color (12%)
aspose.cells.font(3%)
aspose.cells.Style (3%)
aspose.cells.cR (3%)...
A total of 25% of the entire application memory consumption.
For styling, I am using the method you recommended here in the forums for better memory handling. for example:
Style cellStyle = cell.getStyle();
cellStyle.setBorderLine(BorderType.TOP,style.getBorderLine(BorderType.TOP));
cellStyle.setBorderLine(BorderType.BOTTOM,style.getBorderLine(BorderType.BOTTOM));
cell.setStyle(cellStyle);
Please advise...
Thanks,
Ido Raz