Article:		Excel Reports with Apache Cocoon and POI
Subject:		Displaying Excel Charts
Date:		2003-04-11 08:53:31
From:		Kamlesh Barvalia
Hi Steve thanks for the informative article. I have two quick questions: 1. How do I display excel charts in the report as opposed to just the text lists. (If I created the chart in the template excel file, will it be created on the client?) 2. Do I need to install POI separately on my app server (websphere 4.0) in addition to Cocoon or does Cocoon include necesasry components from POI? Thanks again. Kamlesh

Previous Message

Next Message

• Displaying Excel Charts
  2003-04-11 16:20:15 Steven Punte
  
  Kamlesh,

  
  Excel has great facilities for charts.
  One would use them in exactly the same
  manner for a simple stating excel file.

  
  However, IF you have an unknown number
  of results (i.e. an unknown number of
  rows of data that will be produced by
  the sql query), then things are more
  tricky.

  
  I haven't attempted this, but I belive
  using Excel "Named Cells" will properly
  bridge between the two technologies.

  
  Cocoon comes with the poi library.

  
  Steve Punte