Excel-DNA = .Net and Excel integration
In order to overcome limitations due to the lack of development of the VBA language, relaying on XLL seems a right option to manipulate Excel environment via more actual languages, like C++ or the .Net flavours.
From all the solutions one can opt to deal with this XLL thing, Excel-DNA is the way to go.
Excel-DNA (Excel Dot Net Assembly) lets integrate .Net and Excel, making possible to create native .xll add-ins for Excel (using .Net programming languages, via Visual Studio), which leverages high-performance in user-defined functions (UDFs) and Excel manipulation from .Net coded applications. It also allows to customize ribbon interfaces. The add-in can be packed into a single .xll file -requiring no installation or registration, only linking from the Excel COM tab manager-.
Continue reading “Excel-DNA”