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).
At A Glance
An overview of ExcelDna features.
- Create Excel Add-In
- Multi-threaded recalculation
- Registration-free RTD servers
- Customized Ribbon interface
- Logging mechanism
- Offloading UDF computations
- Integrated Custom Task Panes
- Clean up ExcelReference
- Add XML schema for .dna
- Add option to pack .pdb
Excel-DNA only requires .NET Framework 4.0 or greater.
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
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.
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.