XP is just a number | |
PerlMonks |
Re: Can Spreadsheet::ParseExcel extract formulas?by jmcnamara (Monsignor) |
on Oct 07, 2010 at 23:08 UTC ( [id://864108]=note: print w/replies, xml ) | Need Help?? |
It isn't possible to extract a formula from an Excel file using Spreadsheet::ParseExcel. The documentation should be clearer on this.
The main reason is that formulas are stored in Excel as parsed symbols in an RPN structure. In theory it would be possible to deparse this back into the textual representation of the formula but it is one of those large time consuming features that I and the previous maintainers never got around to.
--
In Section
Seekers of Perl Wisdom
|
|