Workaround to ParseExcel losing graphs

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?

Comment on Workaround to ParseExcel losing graphs

Replies are listed 'Best First'.
Re: Workaround to ParseExcel losing graphs by Ratazong (Monsignor) on Mar 20, 2013 at 10:52 UTC
Maybe using Win32::OLE is an option for you. See Using Win32::OLE and Excel - Tips and Tricks how to use it. However it requires you being in an Windows-environment and having Excel installed. HTH, Rata	[reply]
Re^2: Workaround to ParseExcel losing graphs by Anonymous Monk on Mar 20, 2013 at 10:55 UTC
That is the problem. I am restricted to working in linux environment. Now what??	[reply]
Re^3: Workaround to ParseExcel losing graphs by marto (Cardinal) on Mar 20, 2013 at 11:01 UTC
You could research automating Libre/Openoffice. Re^5: Converting doc to txt without WIN32::OLE Super Search etc. Also the quote you attribute to be from Spreadsheet::ParseExcel is actually from Spreadsheet::WriteExcel.	[reply]
Re^4: Workaround to ParseExcel losing graphs by Anonymous Monk on Mar 20, 2013 at 11:19 UTC
Re^5: Workaround to ParseExcel losing graphs by marto (Cardinal) on Mar 20, 2013 at 11:24 UTC
Some notes below your chosen depth have not been shown here
Re^4: Workaround to ParseExcel losing graphs by Anonymous Monk on Mar 20, 2013 at 13:59 UTC
Re^5: Workaround to ParseExcel losing graphs by marto (Cardinal) on Mar 20, 2013 at 14:02 UTC
Re: Workaround to ParseExcel losing graphs by choroba (Cardinal) 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. لսႽ† ᥲᥒ⚪⟊Ⴙᘓᖇ Ꮅᘓᖇ⎱ Ⴙᥲ𝇋ƙᘓᖇ	[reply]
Re^2: Workaround to ParseExcel losing graphs by Anonymous Monk on Mar 20, 2013 at 14:03 UTC
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	[reply]
Re^3: Workaround to ParseExcel losing graphs by marto (Cardinal) on Mar 20, 2013 at 14:08 UTC
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.	[reply]
A reply falls below the community's threshold of quality. You may see it by logging in.
Re^2: Workaround to ParseExcel losing graphs by Anonymous Monk on Mar 20, 2013 at 14:01 UTC
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.	[reply]
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.	[reply]
Re^2: Workaround to ParseExcel losing graphs by Anonymous Monk on Mar 21, 2013 at 06:52 UTC
well then, I will go ahead with Win32::OLE... afterall, my project has to be completed. Thanks a lot Monks...	[reply]

Back to Seekers of Perl Wisdom