File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes Other JSE/JEE APIs and the fly likes XY chart in Excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Other JSE/JEE APIs
Bookmark "XY chart in Excel" Watch "XY chart in Excel" New topic
Author

XY chart in Excel

Vinod Tiwari
Ranch Hand

Joined: Feb 06, 2008
Posts: 459
    
    1
Hi,

I need to create an application while reads some set of data from the database and plots the XY graph with data in an excel and sends the report to a mailing list.

Could someone please guide me how can we plot the XY graph in excel using java?

Thanks
Vinod
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 41861
    
  63
The most capable API for creating Excel files in Java is Apache POI, and I'm fairly certain that it can't create embedded charts.

Your best bet may be to use OpenOffice in server mode, and use its Java API to drive the creation of such a file. That has a fairly steep learning curve, though.


Ping & DNS - my free Android networking tools app
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: XY chart in Excel