help needed with POI user model



Hello

We need to create output in a excel and draw charts using the output data.
Since Current POI doesn't draws charts, so we are doing same with macros
(which draws the charts).

We have a template, which contains macros to draw charts. We read this
template using POI usermodel workbook class, add content and send it to user
(jsp). This works perfectly fine till excel size is less than 1 MB. We are
facing a problem, if excel output goes beyond 1MB, the output file looses
its formtting+Macros in it.

Has anybody encountered similar problems? What is the solution for this. I
searched POI document, Bugzlilla, but couldn't find this problem being
reported. Is there anyway to use POI when output is greater than 2 MB?

Thanks for your help

regards
Holla


.



Relevant Pages

  • Probleme mit POI
    ... welcher verschiedene Excel Dateien in eine Arbeitsmappe ... Die kurze POI Doku sagt mir, dass es recht einfach ist Excel Dateien ... Failed to complete poi runner normally. ...
    (de.comp.lang.java)
  • Re: Java MS Excel read write question
    ... I am using HSSFSerializer - POI for last two years. ... I need to move data between Java and Excel (mostly read data from Excel ... Horror stories? ... I've used jExcelAPI to write a couple of apps that processed data from ...
    (comp.lang.java.programmer)
  • Issues with shared vs. non-shared formulas on somewhat wide spreadsheets
    ... I'm on XP, using Excel 2003. ... I have a somewhat wide spreadsheet. ... When I run the app that uses POI, if I only read the leftmost columns, ... I've tried experiments of creating multiple worksheets, ...
    (microsoft.public.excel.misc)
  • Re: Java MS Excel read write question
    ... I need to move data between Java and Excel (mostly read data from Excel ... I've used jExcelAPI to write a couple of apps that processed data from Excel 2000 files. ... Not tried POI, but I imagine that's had more development seeing as it's part of Apache. ...
    (comp.lang.java.programmer)
  • Tools such as ASAP utilities that can be used to draw charts in excel
    ... draw charts in excel? ... KAS. ... Prev by Date: ...
    (microsoft.public.excel.charting)