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?
我在非托管c++中有一些数学模拟,现在我需要将它们与Excel集成(这样就可以从Excel中调用函数并返回值)。我不想使用任何VBA,所以我想我必须实现XLL插件。我希望尽可能少地使用第三方附加框架。有人能给我推荐一个好的教程吗?
1 个解决方案
#1
13
Starting out with the SDK can be a bit unpleasant. I'd suggest you try one of the toolkits:
从SDK开始可能有点不愉快。我建议你试试其中一个工具包:
- XLW (http://xlw.sourceforge.net/) is a standard open-source C/C++ wrapper.
- XLW (http://xlw.sourceforge.net/)是一个标准的开源C/ c++包装器。
- 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++.
- Keith Lewis的NXLL库(http://nxll.codeplex.com/)可能值得一看,如果你觉得自己更有冒险精神,喜欢现代风格的c++。
- The Rolls-Royce of C/C++ toolkits for Excel is XLL+ (http://www.planatechsolutions.com/xllplus/).
- Excel的C/C++工具包的罗尔斯罗伊斯是XLL+ (http://www.planatechsolutions.com/xllplus/)。
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).
当然,对于托管代码,或者制作一个c#包装器,从。net UDFs调用非托管的c++代码,您可以使用Excel-DNA (http://exceldna.codeplex.com)。
#1
13
Starting out with the SDK can be a bit unpleasant. I'd suggest you try one of the toolkits:
从SDK开始可能有点不愉快。我建议你试试其中一个工具包:
- XLW (http://xlw.sourceforge.net/) is a standard open-source C/C++ wrapper.
- XLW (http://xlw.sourceforge.net/)是一个标准的开源C/ c++包装器。
- 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++.
- Keith Lewis的NXLL库(http://nxll.codeplex.com/)可能值得一看,如果你觉得自己更有冒险精神,喜欢现代风格的c++。
- The Rolls-Royce of C/C++ toolkits for Excel is XLL+ (http://www.planatechsolutions.com/xllplus/).
- Excel的C/C++工具包的罗尔斯罗伊斯是XLL+ (http://www.planatechsolutions.com/xllplus/)。
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).
当然,对于托管代码,或者制作一个c#包装器,从。net UDFs调用非托管的c++代码,您可以使用Excel-DNA (http://exceldna.codeplex.com)。