Extract Excel graphs

tarunkhanna has asked for the wisdom of the Perl Monks concerning the following question:

Replies are listed 'Best First'.
Re: Extract Excel graphs by GrandFather (Saint) on Oct 01, 2011 at 09:07 UTC
You really need to tell us more about the problem, and even then it's unlikely we will do more than point you at a bunch of modules. This is likely to be a rather non-trivial problem because Excel graphs are not a common browser supported object type. If you have the opportunity to massage the data on a PC then you could export the graphs as a suitable image type. Otherwise, most likely, you will need to recreate the graphs from the original data using a suitable charting module. In any case the devil is in the details and you have not given us any details. True laziness is hard work	[reply]
Re^2: Extract Excel graphs by planetscape (Chancellor) on Oct 01, 2011 at 15:59 UTC
Otherwise, most likely, you will need to recreate the graphs from the original data using a suitable charting module. To that end (should the OP decide to use something sane): Personally, I really like gnuplot. There are other ideas in the nodes below. Creating Graphs - Best module to use State of the Ch(art) in Perl Graphics Module making a scientific chart Perl module for chart drawing? How to creata a Line Graph Pixel-based Plotting in Perl? Line Graph Image Manipulation Better plotting than GD::Graph? Real time data graphs. drawing (visualizing) directed graphs How to print/draw a network graph Really slick Charts and Graphs Portable simple line graph module? Charting Modules Professional, "a-la-OpenOffice", 3D graphs develop animation and graphics creating graphs (YA) Q: re "which graphics module?" I'm also looking at SVG for a project of mine (An SVG Case Study: Integrated, Dynamic Avalanche Forecasting has some nice examples). HTH, planetscape	[reply]
Re: Extract Excel graphs by Anonymous Monk on Oct 01, 2011 at 07:30 UTC
So do you want to serve images or excel files or what?	[reply]
Re^2: Extract Excel graphs by tarunkhanna (Novice) on Oct 01, 2011 at 08:02 UTC
I want to extract only graphs and not tables and display those graphs in browser using CGI programming. Thanks and Regards	[reply]
Re^3: Extract Excel graphs by Anonymous Monk on Oct 01, 2011 at 08:54 UTC
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?	[reply]
Re^4: Extract Excel graphs by tarunkhanna (Novice) on Oct 01, 2011 at 19:51 UTC
A reply falls below the community's threshold of quality. You may see it by logging in.
Re: Extract Excel graphs by Anonymous Monk on Oct 01, 2011 at 20:23 UTC
Since you and/or your company already took away the jobs of people who actually knew how to do it ... don't you know how to do it? :-/	[reply]
Re^2: Extract Excel graphs by kangelos (Initiate) on Oct 02, 2011 at 09:29 UTC
I one word don't, simultaneous connections will hang while excel single threads the graph creation. Use gnuplot instead so that each CGI invocation will spawn a separate gnuplot instance.	[reply]