This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
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: 41085
    
  43
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
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: XY chart in Excel
 
Similar Threads
how i do get network graph ?
How to draw Fan Graphs in Excel File using a ResultSet
Plotting a graph in Excel
Excel Charts and JSPs
cewolf XY Chart