Build XLL Add-in using Excel DNA in Visual Studio

Subscribe Now!
New videos every Weekend!

Like what I do? Donate

Did I help you? Did one of my tutorials save you sometime? 

You can say thank you by buying me a cup of coffee, I go through a lot of it.

Help keep Greater Good resources free for everyone. Please donate today. 

Excel-DNA is an open-source project that lets you create .XLL add-ins using C#, VB.Net, or F#. 

It is a great solution for the development of high-performance user-defined functions, it also supports multi-threaded recalculation, custom ribbon interfaces, custom task pane, IntelliSense for function and it requires no installation or registration and therefore helps in distribution to reduced privilege environments.  More tutorials will be uploaded.

Related Links

https://github.com/Excel-DNA

https://www.nuget.org/packages/Microsoft.Office.Interop.Excel/

https://www.nuget.org/packages/ExcelDna.IntelliSense/

https://docs.excel-dna.net/

https://docs.excel-dna.net/excel-c-api/

<CustomUI>
<customUI xmlns="http://schemas.microsoft.com/office/2009/07/customui">
<ribbon startFromScratch="false">
    <tabs>
    <tab id="customTab" label="EXCEL DNA">
        <group id="Group5" label="Loader">
            <button id="Button5" label="Upload to Database" size="normal" onAction="Macro1" imageMso="FilePublishAsWebPage"/>
            <button id="Button6" label="Run Reports" size="normal" onAction="Macro1" imageMso="Chart3DBarChart"/>
            <button id="Button7" label="Misc" size="normal" onAction="Macro1" imageMso="MacroConditions"/>
            <button id="Button8" label="Info" size="normal" onAction="Macro1" imageMso="Info"/>
        </group>
    </tab>
</tabs>
</ribbon>
</customUI>
</CustomUI>