java to create charts in excel

[Achal Jalan]

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]

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.

[Nigel Browne]

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]

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