On Thu, 26 Apr 2012, Sébastien Lorber wrote:
We noticed the apparition on POI 3.8 of the SXSSF workbook which permits to stream. First i'd like to know about that: Is it possible to make it stream directly to the servlet stream instead of streaming to a file?
No. We need to temporarily store bits of the file (PackageParts effectively) as we generate the workbook, then assemble it all together before the file is ready. Only at that point can you send it to the user
The problem we have at work is that we work for a large car industry which still uses XLS files on many countries, not XLSX. Is it possible to stream as well the creation of XLS files?
No, the file formats are different. With XLSX you can generate some parts independently of others, so we can arrange to keep certain key bits in memory and stream the rest. With XLS, there are too many forward and backward references between the bits of the file for this to work
Nick
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
