Welcome to the Excel-DNA wiki!
📄️ Getting Started with Excel-DNA
Do this first:
📄️ Excel-DNA Performance
With Excel-DNA you can create high-performance UDFs by using a restricted set of types, and taking responsibility for ensuring that exceptions are not leaked. Otherwise, ExcelDna is designed be flexible and make it easy to expose your functions safely - these extensions perform well but are not tuned for high-performance interop.
📄️ Introduction - excel-dna.github.io
The Excel C API was first introduced in Excel '95 and has continuously evolved with new versions of Excel. Excel-DNA uses the C API to integrate with Excel, though Excel-DNA add-in can also use the COM Automation interfaces where needed.
📄️ Adding a Keyboard Shortcut
You can register a shortcut key for your macro in your AutoOpen.
📄️ Debugging Addins and Excel-DNA
Debugging user code in your add-in
📄️ Excel-DNA Packing Tool
Excel-DNA has a packing tool that allows you to create a single-file .xll add-in.
📄️ FSharp Standalone Assemblies
F# assemblies can be compiled with a -standalone switch that embeds the F# runtime into the assembly, and allows it to run without requiring additional assemblies.
📄️ Integrating with VBA
Excel-DNA can make it easy to call between .NET and VBA. This means existing VBA code need not be rewritten. And end users are likely to find VBA much easier to develop in.
📄️ Returning 1-D Arrays
NOTE: This guide only applies to old version of Excel that does not support Dynamic Arrays.