XLL Excel插件在非托管C ++中

问题描述:

我在非托管C ++中有几个数学模拟,现在我需要将它们与Excel进行集成(这样可以从Excel中调用函数并获取值)。我不想使用任何VBA,所以我想我必须实现一个XLL插件。我想使用尽可能少的第三方附加框架。有人可以指点一个好的教程吗?

I have a few mathematical simulations in unmanaged C++ and now I need to integrate them with Excel (so that it is possible to call the functions from Excel and get the values back). I don't want to use any VBA, so I guess I have to implement an XLL addin. I would like to use as few third party additional frameworks as possible. Could someone point me to a good tutorial?

开始使用SDK可能会有点不愉快。
我建议您尝试其中一个工具包:

Starting out with the SDK can be a bit unpleasant. I'd suggest you try one of the toolkits:

  • XLW (http://xlw.sourceforge.net/) is a standard open-source C/C++ wrapper.
  • Keith Lewis's NXLL library (http://nxll.codeplex.com/) might be worth a look if you are feeling a bit more adventurous, and like modern-looking C++.
  • The Rolls-Royce of C/C++ toolkits for Excel is XLL+ (http://www.planatechsolutions.com/xllplus/).

当然对于托管代码,或者做一个C#包装器,它从.NET UDF调用非托管C ++代码,你可以使用Excel-DNA( http://exceldna.codeplex.com )。

Of course for managed code, or to make a C# wrapper that calls your unmanaged C++ code from .NET UDFs, you'd use Excel-DNA (http://exceldna.codeplex.com).