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

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

View raw message