This thread is for discussing the upcoming release. Please post usage questions to the poi-user list.
Yegor On Thu, Aug 11, 2011 at 3:43 PM, Guilherme Vieira <[email protected]> wrote: > 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] >> >> > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
