wood burning stoves 2.0*
The moose likes Java in General and the fly likes java to create charts in excel Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Java » Java in General
Bookmark "java to create charts in excel" Watch "java to create charts in excel" New topic
Author

java to create charts in excel

Achal Jalan
Greenhorn

Joined: Nov 23, 2004
Posts: 21
Hi,

I need to be able to create excel charts in a wrkbook using java.

Any clues or sample code ?

Thanks in advance
Achal
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

POI give you access to Excel in a Java environment. However, I can't remember if VBA stretches to creating charts. I suspect not, but someone may correct me.


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
Nigel Browne
Ranch Hand

Joined: May 15, 2001
Posts: 673
You can't create an excel chart with Java using POI, but if you already have a chart template in an excel file then you can modify the data and those changes will be reflected in the chart.
VBA does have a Chart object but I don't know how you access that with Java
[ March 23, 2005: Message edited by: Nigel Browne ]
Achal Jalan
Greenhorn

Joined: Nov 23, 2004
Posts: 21
Thanks for the suggestion. I think i will go about doing that, the only problem I have is time. So if there exists any sample code to read from and update spreadheets using POI it will be very very very helpful.

Cheers guys
 
Consider Paul's rocket mass heater.
 
subject: java to create charts in excel