Beefy Boxes and Bandwidth Generously Provided by pair Networks
Pathologically Eclectic Rubbish Lister

Workaround to ParseExcel losing graphs

by Anonymous Monk
on Mar 20, 2013 at 10:35 UTC ( #1024491=perlquestion: print w/replies, xml ) Need Help??

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

Spreadsheet::ParseExcel says ----> "You can only rewrite the features that Spreadsheet::WriteExcel supports so macros, graphs and some other features in the original Excel file will be lost. Also, formulas aren't rewritten, only the result of a formula is written." I have an xls whose contents has to be edited. I have successfully been able to edit the data but I am losing the graphs and i need to edit the graphs also. Is there any workaround for this?

Replies are listed 'Best First'.
Re: Workaround to ParseExcel losing graphs
by Ratazong (Monsignor) on Mar 20, 2013 at 10:52 UTC
      That is the problem. I am restricted to working in linux environment. Now what??
Re: Workaround to ParseExcel losing graphs
by choroba (Archbishop) on Mar 20, 2013 at 12:06 UTC
    Crossposted at StackOverflow. It is considered polite to inform about crossposting so people not attending both sites do not waste their efforts on solving a problem already solved at the other corner of the Internet.
    لսႽ ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ
      I am also a registered user here but the site is unable to retain my session and m not able to post under my user name when logged in. My user name is: tc_blr

        Have you reported this problem? Perl Monks Discussion would be the place to do so. I've been using the site for many years and never experienced this.

        A reply falls below the community's threshold of quality. You may see it by logging in.
      I have only posted that coz i am not able to get a proper workaround. i thought those great minds who are in either of these sites could also help me out.
Re: Workaround to ParseExcel losing graphs
by sundialsvc4 (Abbot) on Mar 20, 2013 at 17:25 UTC

    Approaching this question from the other side, is there any alternate format that Excel can produce, which would be more suitable to process?

    You may well find that “limited to the Linux environment” is simply not a sustainable technical stricture for this project.   It may well be that, in order to get where you need to go, you have to engage the Windows environment more closely than you now do ... especially if you express a need to edit the graphs.   I think that, at this point, there is a pretty sustainable chance that you simply cannot be successful with your present approach, and if so, you need to make that assessment very soon.

      well then, I will go ahead with Win32::OLE... afterall, my project has to be completed. Thanks a lot Monks...

Log In?

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: perlquestion [id://1024491]
Front-paged by Arunbear
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others meditating upon the Monastery: (3)
As of 2022-07-01 07:28 GMT
Find Nodes?
    Voting Booth?
    My most frequent journeys are powered by:

    Results (98 votes). Check out past polls.