Wiki | Excel-DNA

📄️ AssemblyLoadContext-Notes

https://docs.microsoft.com/en-us/dotnet/core/dependency-loading/loading-managed

📄️ Async-Notes

Excel-DNA supports two types of async function:

When the ExcelDna.AddIn NuGet package is installed into a project, some additional MSBuild targets are defined. These are used to copy the required .xll native add-in into the output directory, and create single-file packed versions of the add-in.

📄️ COM-exports-for-VBA-access

Excel-DNA supports registering the .xll as a regular COM library, which can then be accessed from VBA (either late-bound via CreateObject or referenced in a project via Tools->References. This allows COM-visible classes in the add-in to be instantiated and accessed from VBA, with two advantages over regular COM libraries:

📄️ COM-object-model-notes

* You should only use the Excel COM object model from the main Excel thread. Thus not from other threads, Tasks that you create, timer callbacks that you set up. It's safe to call it from a ribbon callback, of any macro (ExcelCommand). If you have a timer or some other thread that needs to do work back on the main thread, you can start a macro context running on the main thread with a call to ExcelAsyncUtil.QueueAsMacro(...). This waits for Excel to be ready, then runs the delegate you pass. In there, you can use the object model.