Preserve Excel formulas when using Spreadsheet::ParseExcel

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

Replies are listed 'Best First'.
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.	[reply]
Re^2: Preserve Excel formulas when using Spreadsheet::ParseExcel by manimarank (Novice) on Dec 12, 2007 at 04:30 UTC
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.	[reply]
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"	[reply]