🗃️ Excel Programming Interfaces
3 items
📄️ IntelliSense
Excel includes a feature that enables users to utilise functions more effectively by displaying pop-up description regarding the function and its parameters. Examples of IntelliSense in action can be seen in the figure below:
📄️ Accepting Range Parameters in UDFs
Parameters with the type of Excel's Range COM object are not directly supported by Excel-DNA. There is a list of allowed parameter types here: Reference for data types in UDFs
📄️ Asynchronous Functions
Excel-DNA has a core implementation to support asynchronous functions. Two primary ways this could be implemented is through:
📄️ Creating a Help File
With the HelpTopic property of the ExcelFunction attribute, you can add a pointer to a topic in a .chm help file, or a url with more detailed information.
📄️ Customizing Ribbons
Setting Ribbon Properties
📄️ .NET runtime support
Excel-DNA continues to support .NET Framework 4.x. For the core add-in libraries the minimum version is v4.5.2, but I recommend targeting v4.7.2 (net472) or v4.8 (net48) for the best compatiiblity with libraries and Windows releases.
📄️ Extended Registration
Nullable parameter
📄️ Installing Your Add-in
Ease of deployment is one of the great advantages of making your Excel add-ins using Excel-DNA. This page provides some notes on the different approaches to installing your add-in.
📄️ Optional Parameters and Default Values
Update//github.com/Excel-DNA/Registration. I leave the documentation below as applying to the core Excel-DNA library. _
📄️ Excel-DNA properties in SDK-style project files
The following project properties are recognized by the Excel-DNA build task, and can be used to customize the build output.
📄️ Updating Project File to SDK-Style
.NET SDK-style projects are a new project format introduced with .NET Core 2.0, which allows developers to build and manage .NET projects in a simplified way. Unlike the traditional .NET Framework project format, which requires a complex XML-based configuration file, SDK-style projects use a simpler and more intuitive format based on a set of pre-defined templates.