poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Yegor Kozlov <yegor.koz...@dinom.ru>
Subject Re: one week's countdown to tagging 3.8-beta4
Date Thu, 11 Aug 2011 12:18:58 GMT
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
<jguilhermemv@gmail.com> 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 <yegor.kozlov@dinom.ru>
>
>> >
>> > 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: dev-unsubscribe@poi.apache.org
>> For additional commands, e-mail: dev-help@poi.apache.org
>>
>>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message