https://bz.apache.org/bugzilla/show_bug.cgi?id=69838
--- Comment #1 from PJ Fanning <[email protected]> --- If you want to work on it, try it out. Even if we don't like the code, you can use your own code in your own project. I am skeptical as to whether SXSSFWorkbook can support this as is. It might be safer to create a new class that shares code with SXSSFWorkbook. I don't want to break existing use cases by making big changes in SXSSFWorkbook to facilitate new functionality and then finding that code uses more memory or accidentally changes behaviour for existing users. SXSSFWorkbook can only access pre-existing sheets and their rows if you create an XSSFWorkbook and wrap that with an SXSSFWorkbook. XSSFWorkbook uses lots of memory. I have some sample code that streams an input file and that writes it back out to SXSSF in a streaming way - where you can modify the data or add to it while writing out. It may not handle all use cases. https://github.com/pjfanning/excel-streaming-reader/wiki/Streaming-copy-with-SXSSF There are other Java libs for Excel that might be worth trying. * Apache Fesod (https://github.com/apache/fesod) - previously known as fast-excel before it joined the ASF. Uses POI under the hood for some stuff so it may have some of the problems that you see with POI. * https://github.com/dhatim/fastexcel - a different project that has the overused fastexcel name - its code no longer uses POI -- You are receiving this mail because: You are the assignee for the bug. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
