Re^3: Extract Excel graphs

[Anonymous Monk]

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?

[tarunkhanna]

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.

[tarunkhanna]

Hi

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

Thanx and Regards.

[furry_marmot]

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

[Anonymous Monk]

I'm confident one of OpenOffice::UNO or https://github.com/dagwieers/unoconv can export charts as images

I wouldn't even be surprised if you could use ImageMagick convert :)

[tarunkhanna]

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.