my dog learned polymorphism*
The moose likes Swing / AWT / SWT and the fly likes Display Chart Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Java » Swing / AWT / SWT
Bookmark "Display Chart" Watch "Display Chart" New topic
Author

Display Chart

mohan rajv
Ranch Hand

Joined: Jan 28, 2009
Posts: 30
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
Marshal

Joined: Mar 22, 2005
Posts: 39541
    
  27
Charts are not stored as image data in an Excel file, so it's not possible to extract and save them as images.


Ping & DNS - updated with new look and Ping home screen widget
mohan rajv
Ranch Hand

Joined: Jan 28, 2009
Posts: 30
is there any private api's available for extracting those charts as objects?
Gregg Bolinger
GenRocket Founder
Ranch Hand

Joined: Jul 11, 2001
Posts: 15286
    
    6

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.


GenRocket - A Test Data Generation Platform
mohan rajv
Ranch Hand

Joined: Jan 28, 2009
Posts: 30
i will try this api and tell you
Gaurav Purandare
Greenhorn

Joined: Apr 06, 2009
Posts: 19
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
Gaurav Purandare
Greenhorn

Joined: Apr 06, 2009
Posts: 19
Aspose could serve you better in case of java
mohan rajv
Ranch Hand

Joined: Jan 28, 2009
Posts: 30
Aspose is not a freeware rite?
mohan rajv
Ranch Hand

Joined: Jan 28, 2009
Posts: 30
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
Marshal

Joined: Mar 22, 2005
Posts: 39541
    
  27
I'd say that's pretty standard behavior for an evaluation copy.
mohan rajv
Ranch Hand

Joined: Jan 28, 2009
Posts: 30
then now what should i do?
i have to buy that jar files full version or any other way for this problem?
Ulf Dittmer
Marshal

Joined: Mar 22, 2005
Posts: 39541
    
  27
If you want to use it, then you have to purchase it, yes. That's how commercial software works.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Display Chart
 
Similar Threads
How can I paint a chart in the jsp
Showing image from servlet
Applet is not getting loaded in client machine
Outputstream to image
cewolf