Excel-DNA - Free and easy .NET for Excel

This repository contains the core Excel-DNA library.

Please refer to

• Excel-DNA Website,
• Excel-DNA Wiki Pages (on GitHub), and
• Excel-DNA Documentation

for additional information.

Support is on the Excel-DNA Google group.

Arup

This is a fork that makes one change to the base Dna to fix an issue where COM plugins are failing for some users. This is due to Dna trying to write to the machine hive when it does not have permission to. Dna tries to do this to account for the possibility of Excel being run "As Administrator", however, at Arup we do not need to worry about this. Therefore, we turn off this machine write hive feature by making the RegistrationUtil.CanWriteMachineHive() function always return false.

Building

To build see here.

NOTE: Before building making sure that:

1. You have installed the C++ modules on Visual Studio
2. You have set environment variable MSBUILD_PATH to the location of MSBuild.exe. Do that instead of setting the path directly in MasterBuild.cmd as per the original build instructions. If using Visual Studio Professional the command is:
   set MSBUILD_PATH="C:\Program Files\Microsoft Visual Studio\2022\Professional\Msbuild\Current\Bin\amd64\MSBuild.exe"
3. You have pulled down the non-Arup-Group versions of IntelliSense, Registration, and ExcelDnaDoc. There are not separate Arup-Group versions, but they are required to use this version locally
4. Sometimes having alternative nuget package sources can mess up the build script, turning them off (in Visual Studio Nuget Package Manager) seems to solve this issue
5. Make sure you are cd'd into the MasterBuild folder before running the script (if running from powershell/command line)

The CI/CD pipeline takes care of all the above details and makes the packages available on the ArupcomputeDevops nuget feed. The feed is only updated for packages with new version numbers.