Hello Dev team, According to your limitations notes ( http://poi.apache.org/components/spreadsheet/limitations.html) I should use SXSSFWorkbook <http://poi.apache.org/components/spreadsheet/> to save big amount of data to avoid huge memory usage. My current task is to load big excel file (with at least 2 big worksheets) and add new rows to one of those big sheet. I can read data from big worksheet using the same limitaions page notes (using OPCPackage and XSSFReader) but I cannot add new rows to those worksheets.
I cannot find any way to use XSSFWorkbook no SXSSFWorkbook because of first try to load all data from excel file in constructor (this cause of OutOfMemory exception on my environment) and second one can only use first one as an constructor parameter, it cannot take excel file name and try to load it using rowAccessWindowSize. Because of this I have 2 questions. 1. Is SXSSFWorkbook class usable at all in it's current implementation? As for me most of developers need to update existing excel sheets instead of creating new. Maybe it's time to add some possibility to load big files using the same rowAccessWindowSize idea? 2. Could you please provide me some workaround/proposal to add new rows to big excel file sheet without OutOfMemoryException? Best regards, Senior Software Developer, Skype: vasylshevchuk Cell: +380661044415 Vasyl Shevchuk
