Extending SXSSF to support reading with sliding window is a desirable feature? Am I right in assuming that when you instantiate a Workbook from a FileInputStream, every single sheet, row and cells from the XLSX file is loaded into the Workbook object? If so, don't this cause a large memory footprint? The only way to get around this is to use the XSSF event API? How could I read large XLSX files without having to deal with the low-level event API?
Thanks in advance! 2011/8/10 Yegor Kozlov <[email protected]> > > > > Are you going to implement an autoSizeColumns method for SXSSFWorkbook? > It > > would be very interesting, since most people need to deal with this issue > in > > large XLSX files. > > > > autoSizeColumn is implemented in trunk. Daily builds can be downloaded > form here: > http://encore.torchbox.com/poi-svn-build/ > > > Also it would be interesting if was implemented a way to read large XLSX > > using SXSSFWorkbook, using its sliding window to travel through the rows > in > > large XLSX files with small memory footprint. Are you going to implement > any > > of this? > > > > > > You want to look at the XSSF event API that allows you to read XSLX > with small memory footprint. > http://poi.apache.org/spreadsheet/how-to.html#xssf_sax_api > > Extending SXSSF to support reading with sliding window is not in my plans. > > Yegor > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > >
