🗃️ Excel Programming Interfaces
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
📄️ 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.
📄️ Moving to .NET 7 and Above
The Excel-DNA solution currently supports .NET 6 and .NET Framework 4.x. The rationale behind the decision of not targeting .NET 7 and above at this stage is due to the restriction that the .NET Core series of runtimes imposes. To put simply, the restriction allows only a single version of the runtime to be loaded in a process (see GitHub issue).
📄️ Optional Parameters and Default Values
Update//github.com/Excel-DNA/Registration. I leave the documentation below as applying to the core Excel-DNA library. _
📄️ 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.