Beefy Boxes and Bandwidth Generously Provided by pair Networks
more useful options

Re^4: Extract Excel graphs

by tarunkhanna (Novice)
on Oct 02, 2011 at 16:58 UTC ( #929161=note: print w/replies, xml ) Need Help??

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


I want to extract graphs from excel as image. Can you tell me how to do that on linux platform??

Thanx and Regards.

Replies are listed 'Best First'.
Re^5: Extract Excel graphs
by furry_marmot (Pilgrim) on Oct 03, 2011 at 01:13 UTC

    Dude, do you want to export the graphs as images all at once and then have those images available for viewing? Do you want to export them on the fly? Is there a static set of spreadsheets around? Or are these spreadsheets created on a regular basis? From this data, you can determine what will be your best path.

    But what you're doing is like saying, "I want to fly. How do I do that?" a plane ticket? Buy a plane? Get a jet pack? Get fired out of a cannon?

    Ask a question poorly, and you'll be guaranteed nothing but poor answers. And by the way, from what I've been able to find, you can't do this from Perl -- at least not the way you've described so far. But you might look into writing a macro in OpenOffice.


      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.


        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://929161]
[marto]: hmm, Jeff Google for "flights from Bedford to Glasgow" shows lots of results :p
[choroba]: oh, jet2 didn't show in my search as it only flies on Mondays and Fridays
[choroba]: so, now I need to figure out what to talk about at TPCiG

How do I use this? | Other CB clients
Other Users?
Others contemplating the Monastery: (4)
As of 2018-02-23 10:42 GMT
Find Nodes?
    Voting Booth?
    When it is dark outside I am happiest to see ...

    Results (301 votes). Check out past polls.