I¹m hoping somebody can help me with this. We¹re generating quite large excel files via a web interface and occasionally the size of the file is so large that it causes the app to hang.
Is there a way to incrementally save the file to the file system and then add to it. At the moment all I do is instantiate a XSSFWorkbook and when complete write it out to the file system, but ideally I¹d like to know if I can write to the file system and purge contents from memory. As always any and all help appreciated. Z.
