Article:		Opening Microsoft File Formats to Java
Subject:		Intersted Excel Charting manipulation
Date:		2003-05-16 05:55:32
From:		anonymous2
I'm interested in seen how to do Charts trought POI. It seems posible if the chart is there already and one populate the data sheet with POI.

Showing messages 1 through 6 of 6.

• Intersted Excel Charting manipulation
  2004-01-13 18:32:53  anonymous2 [Reply | View]
  
  
  Use ExtenXLS -- you can modify Charts all you want.
  
  Hey, POI is pretty good, but I think if you want a really good Java Excel tool with commercial support that you should check out ExtenXLS.
  
  We use and recommend the Java Excel API ExtenXLS, which you can download here from Extentech's web site at:
  DOWNLOAD NOW!
  
  This tool is so slick and works so well, we've never even needed support!
  
  Used by JPMorgan/Chase, HP, Ford, and more, so you know it's solid...
• Intersted Excel Charting manipulation
  2007-02-02 04:37:49  liqd [Reply | View]
  
  
  Jxcell is also a good choise to genarate excel apreadsheet file with chart support.
  
  

  http://www.jxcell.net
• Intersted Excel Charting manipulation
  2004-01-13 21:08:31  anonymous2 [Reply | View]
  
  
  I work for JPMorgan/Chase and we're using POI.
• Intersted Excel Charting manipulation
  2004-03-15 09:11:52  lpatel [Reply | View]
  
  
  I am interested in finding out more. Do you first create an excel spreadsheet with chart and then modify it using poi? How does that work? we are trying to do that and we are having problems with formulas?
• Intersted Excel Charting manipulation
  2004-01-13 21:06:59  anonymous2 [Reply | View]
  
  
  We tried ExtenXLS and it just didn't scale well. It often corrupted files and just didn't do what we needed. POI worked great for us.
• Intersted Excel Charting manipulation
  2005-07-18 14:19:53  johnny_shredder [Reply | View]
  
  
  POI is good, no doubt about it. Extentech has a solid product and should not be overlooked especially if you have a budget and want to have more robust handling of existing files.
  
  The older versions of ExtenXLS had scalability problems, however the new version of ExtenXLS (4.1) has fixed this, and is now far more compatible with complex Excel files than POI -- especially files with embedded OLE objects, etc.
  
  ExtenXLS now also not only allows you to create formulas from text strings (like: =sum(a1+b1)) but it will *execute* the formulas in memory. It can then use an XSLT to transform the Java Excel WorkBook to HTML (out of the box) PDF or whatever. A great way to re-use existing Excel files in your applications.
  
  If you want a great supported product, at a reasonable cost considering it includes unlimited support and upgrades, check it out at
  
  http://www.extentech.com/estore/product_detail.jsp?product_group_id=1