Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re^3: Extract Excel graphs

by Anonymous Monk
on Oct 01, 2011 at 08:54 UTC ( #929011=note: print w/ replies, xml ) Need Help??


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

Graphs do not exist outside of Excel, so you can't "extract graphs" , you have to create images :)

Graphing with Perl
Graph generation using MS Excel
Exporting an Excel Chart to PNG using Win32::OLE

Once you have an image file, you can use a CGI programming to display it (if you insist)

How can I use a CGI script to return an image?


Comment on Re^3: Extract Excel graphs
Re^4: Extract Excel graphs
by tarunkhanna (Novice) on Oct 01, 2011 at 19:51 UTC

    Hi

    I saw Win32::OLE module. But it's limitation is that I can use it only with windows. But I want a solution on linux platform. Yeah, I am comfortable with extracting graphs from excel as image. Can you help me with this problem on linux platform?? Thanks and Regards.
Re^4: Extract Excel graphs
by tarunkhanna (Novice) on Oct 02, 2011 at 16:58 UTC

    Hi

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

    Thanx and Regards.

      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?" Uh....buy 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.

      --marmot
        Hi

        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.

        Regards.

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others imbibing at the Monastery: (16)
As of 2014-07-10 13:15 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    When choosing user names for websites, I prefer to use:








    Results (210 votes), past polls