开发者

Library to parse Excel Formulas

开发者 https://www.devze.com 2023-04-13 03:05 出处:网络
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 t

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

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号