Win a copy of Programmer's Guide to Java SE 8 Oracle Certified Associate (OCA) this week in the OCAJP forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

XY chart in Excel

 
Vinod Tiwari
Ranch Hand
Posts: 466
1
IntelliJ IDE Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Rancher
Posts: 42968
73
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic