解析Excel公式的库 [英] Library to parse Excel Formulas

问题描述

我正在寻找一个Excel的AddIn来修改单元格中的公式.查看Microsoft的C#和VBA API，我什至没有看到Formula对象.我所能得到的只是显示的字符串.是否有适用于excel的公式解析器，以便我可以处理类似AST图的内容? (我与语言无关)

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)

谢谢.

推荐答案

没有可访问的内置API解析器，但是有几个人编写了Excel公式解析器(尽管Excel团队一直在移动目标杆).参见
Ewbi的c#
和

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

这篇关于解析Excel公式的库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！