in reply to Can Spreadsheet::ParseExcel extract formulas?

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.

--
John.

  • Comment on Re: Can Spreadsheet::ParseExcel extract formulas?

Replies are listed 'Best First'.
Re^2: Can Spreadsheet::ParseExcel extract formulas?
by petecm99 (Pilgrim) on Oct 08, 2010 at 12:00 UTC
    Thanks for clarifying that, John!