Open Source .NET Library for Processing Excel Spreadsheets  

ExcelDna allows you to create & deploy Excel Add-Ins using C#, F# or VB .NET.

Excel-DNA is an open source API to integrate .NET into Excel. The API allows you to create high performace user defined functions(UDFs) and more in your native (.xll) add-ins for Excel. You don't need any installation or registration, your entire add-in can be packed into a single .xll.

The Excel-DNA Runtime is free for all use, and is distributed under a permissive open-source license that also allows commercial use. It is developed using .NET and users have to install .NET Framework runtime. The Excel and the .NET code intergrate with each other using Add-In (.xll) that exposes .NET code to excel. You can write you code in text-based (.dna) script files (C#, Visual Basic or F#), or compiled .NET libraries (.dll).

Previous Next

Getting Started with Excel-DNA

The recommended way to install ExcelDNA  is from Nuget, Please use the following command for fasters installation.

Install ExcelDNA from NuGet

 Install-Package ExcelDna.AddIn

Create Excel Functions via .NET API

ExcelDNA gives C# .NET programmers the competency to generate Excel functions inside using C#. You can also use ExcelFunctionAttributes like Name, Description, Category, IsHidden, IsExceptionSafe and more. The IsMacroType attribute changes the parameters Excel-DNA uses when registering the function.

Support for Dynamic Arrays

The open source .NET API Excel-DNA also supports the use of dynamic arryays inside excel. when you write an dynamic arrya formula it determines if the formula has the potential to return multiple values.

Diagnostic Logging

ExcelDNA API allows .NET developers to use diagnostic logging while working with Excel Add-In. Excel-DNA uses the standard .NET System.Diagnostics.Trace mechanisms for diagnostic logging.