poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominik Stadler <dominik.stad...@gmx.at>
Subject Re: Excel Tables and Streaming Workbooks
Date Wed, 25 Dec 2013 20:41:07 GMT
Hi,

it seems there is currently no support for tables in SXSSF currently,
without anyone submitting patches it probably is not going to be added
soon, anyone wants to take a stab?

Thanks... Dominik.

On Tue, Dec 24, 2013 at 8:46 PM, Craig Milhiser <cmilhise@us.ibm.com> wrote:
> I have a program that creates a MS Excel XLSX  workbook (XSSF) then writes
> sheets with many tables with some conditional formatting in the tables.
> There are no cell formulas, just values.  The conditional formatting is
> cell value not between cellA and cellB .  The XLSX file created is about
> 9MB.  However the Java program takes 2 GB of RAM to run.
>
> I am starting to add more data to the sheet and I am getting out of memory
> errors.  I am trying to switch to SXSSFWorkbook.  I do not need to
> reference rows behind the current position so this will be OK for my
> application.  However the createTable method is in XSSFSheet, not
> SXSSFSheet.  Java reports the two as incompatible and not castable.
>
> How can I create a table in a SXSSFSheet?
>
> Thanks

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


Mime
View raw message