Beefy Boxes and Bandwidth Generously Provided by pair Networks
The stupid question is the question not asked

Re^6: Extract Excel graphs

by tarunkhanna (Novice)
on Oct 03, 2011 at 04:50 UTC ( #929265=note: print w/ replies, xml ) Need Help??

in reply to Re^5: Extract Excel graphs
in thread Extract Excel graphs


let me be clear

I have an excel which has number of sheets in it. Each sheet has number of graphs. I want a script which can extract all the graphs from all the sheets in the above mentioned excel as image.


Comment on Re^6: Extract Excel graphs
Replies are listed 'Best First'.
Re^7: Extract Excel graphs
by furry_marmot (Pilgrim) on Oct 03, 2011 at 19:40 UTC

    The functionality to export or copy the graphs as images lies in the Excel application. You're best bet is to extract the images on a Windows machine. If that is absolutely not possible, then try the API.

    Depending how many charts there are, and if you have access to a Windows machine, it might actually be faster to just copy them all to the clipboard, one by one, and paste them into Paint or Photoshop or IrfanView or whatever. This works quite well.

    Good luck!


Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://929265]
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others chilling in the Monastery: (2)
As of 2015-11-27 01:54 GMT
Find Nodes?
    Voting Booth?

    What would be the most significant thing to happen if a rope (or wire) tied the Earth and the Moon together?

    Results (712 votes), past polls