Beefy Boxes and Bandwidth Generously Provided by pair Networks
Keep It Simple, Stupid
 
PerlMonks  

Preserve Excel formulas when using Spreadsheet::ParseExcel

by manimarank (Novice)
on Dec 11, 2007 at 12:40 UTC ( #656390=perlquestion: print w/ replies, xml ) Need Help??
manimarank has asked for the wisdom of the Perl Monks concerning the following question:

Hi, Is there any module will allow to modify the existing excel file and also to preserve the formulas?.i have tried Spreadsheet::ParseExcel::SaveParser module,but it is not preserve the formulas. Pls Help me.... Regards, MM

Comment on Preserve Excel formulas when using Spreadsheet::ParseExcel
Re: Preserve Excel formulas when using Spreadsheet::ParseExcel
by moklevat (Priest) on Dec 11, 2007 at 15:14 UTC
    It's not clear to me from your node if you mean that the formulas are not preserved, or the values computed from the formulas are not preserved (in other words, the results are not preserved). If you are using Spreadsheet::WriteExcel to write out the Excel binary format, then you should it's important to know that this module does not store results with the formula. The documentation for Spreadsheet::ParseExcel mentions this and notes that the behavior is the same as if you had "Auto Calculation" off.

    Update: Changed some language to avoid possible misinterpretation of tone.

      Hi, Values computed from the formulas are preserved but the cell formula is not preserved.Is any other module available to do the task other than the above mentioned module?..or can you suggest some other solution to preserve formulas while editing the excel sheet.
Re: Preserve Excel formulas when using Spreadsheet::ParseExcel
by strat (Canon) on Dec 12, 2007 at 07:46 UTC

    If you are under Windows, you could use Win32::OLE. As an example, have a look at excelPerl

    Best regards,
    perl -e "s>>*F>e=>y)\*martinF)stronat)=>print,print v8.8.8.32.11.32"

Log In?
Username:
Password:

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

How do I use this? | Other CB clients
Other Users?
Others pondering the Monastery: (6)
As of 2014-08-29 14:58 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    The best computer themed movie is:











    Results (280 votes), past polls