Question posted 2011 · +9 upvotes
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?
Accepted answer +12 upvotes
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/).
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).
External references cited (4)
- xlw.sourceforge.net — http://xlw.sourceforge.net/
- nxll.codeplex.com — http://nxll.codeplex.com/
- planatechsolutions.com — http://www.planatechsolutions.com/xllplus/
- exceldna.codeplex.com — http://exceldna.codeplex.com
Top excel Q&A (6)
- Shortcut to Apply a Formula to an Entire Column in Excel +335 (2011)
- How should I escape commas and speech marks in CSV files so they work in Excel? +136 (2012)
- Convert xlsx to csv in linux command line +96 (2012)
- How to create a link inside a cell using EPPlus +50 (2011)
- IF statement: how to leave cell blank if condition is false ("" does not work) +44 (2013)
- T-SQL: Export to new Excel file +44 (2012)
excel solutions on this site
.