Display Chart

[mohan rajv]

Hi I would like to display a chart from an Excel sheet. Is it possible to get a chart object as an image? If there is an image embedded in a Sheet how can I get all images and save them to a file?

[Ulf Dittmer]

Charts are not stored as image data in an Excel file, so it's not possible to extract and save them as images.

[mohan rajv]

is there any private api's available for extracting those charts as objects?

[Gregg Bolinger]

The best library I've ever used for dealing with MS files in Java is Aspose. I don't know for 100% certain it will do what you need, but I'd be surprised if it didn't.

[mohan rajv]

i will try this api and tell you

[Gaurav Purandare]

I think what you want is to present excel sheet on other application frame / just display the chart( Excel Sheet) somewhere...

If this is the case you should dwell deeper in to Object Linking and Embedding / any of the Microsoft technologies like COM to display such objects or to embed them,

[Gaurav Purandare]

Aspose could serve you better in case of java

[mohan rajv]

Aspose is not a freeware rite?

[mohan rajv]

I tried the demo version.for every exectution it is generating a sheet with the contents of
"
Evaluation only. Created with Aspose.Cells for Java.
It is strictly prohibited from using it in the production of any software.
Any violation of this provision shall require a mandatory purchase of pay license
as well as expose the user to other legal recourse for collection and punitive damages.

"

[Ulf Dittmer]

I'd say that's pretty standard behavior for an evaluation copy.

[mohan rajv]

then now what should i do?
i have to buy that jar files full version or any other way for this problem?

[Ulf Dittmer]

If you want to use it, then you have to purchase it, yes. That's how commercial software works.