Library to parse Excel Formulas
I'm looking to make an AddIn for excel that modifies formulas in cells. Looking at Microsoft's C# and VBA API, I don't even see a Formula object. All I can get is the string that is displayed. Is there开发者_开发问答 a formula parser for excel so that I can mess with something like an AST graph? (I'm language agnostic)
Thanks.
There is not an accessible built-in parser with an API, but several people have written Excel formula parsers (although the Excel team keep moving the goalposts). See
Ewbi's c#
and Rob Van Gelder's VBA
精彩评论