Anyone know how to do this ?
Given an Excel formula like
how can I parse it and evaluate it???
There are expression evaluators at
but none specifically mention Excel.
Is there some formal definition of the Excel formula language? If so, one might expect that something like Lex and Yacc could be used. But that is a bit too much heavy lifting for me.
What about tweaking one of the existing expression evaluators ? Anyone have experience/suggestions. And yes I do want to parse AND evaluate, because I want to be able to identify cells that have been referenced in formulae