Re^2: Can Spreadsheet::ParseExcel extract formulas?

I did a search in the CPAN module documentation for 'formula' - nothing jumped out at me. There was a blurb about reading formulas created by WriteExcel -

"This module cannot read the values of formulas from files created with Spreadsheet::WriteExcel unless the user specified the values when creating the file (which is generally not the case). The reason for this is that Spreadsheet::WriteExcel writes the formula but not the formula result since it isn't in a position to calculate arbitrary Excel formulas without access to Excel's formula engine."

My input spreadsheet was not created by WriteExcel, so I assume this comment does not apply. I also looked in my site/lib install folder for examples, there were none. There are plenty for WriteExcel, but ParseExcel is rather sparse.

Comment on Re^2: Can Spreadsheet::ParseExcel extract formulas?

Replies are listed 'Best First'.
Re^3: Can Spreadsheet::ParseExcel extract formulas? by Corion (Patriarch) on Oct 07, 2010 at 19:56 UTC
Quoting Spreadsheet::ParseExcel TODO ... Add Formula support, Hyperlink support, Named Range support. I would assume from that that formulae are currently unsupported.	[reply]
Re^4: Can Spreadsheet::ParseExcel extract formulas? by petecm99 (Pilgrim) on Oct 07, 2010 at 20:11 UTC
I can also assume this means that it does not yet handle evaluating formulae, yet could have a method for retrieving the un-evaluated cell contents. Rather ambiguous, if you catch my drift. I maintain that my question is still valid - I could be missing something simple...certainly doesn't hurt to ask!	[reply]