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/ )是标准的开源C / C ++包装器。
- Keith Lewis的NXLL库( http://nxll.codeplex.com/ )可能值得一看,如果你感觉到有点冒险,像现代的C ++。
- Excel的C / C ++工具包的劳斯莱斯是XLL +( http://www.planatechsolutions.com/xllplus/ )。
- 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).