Obsolete

📄️ Getting Started with Excel-DNA

Do this first:

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

Introduction

📄️ Background

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.

📄️ Home