Bot releases are visible (Hide)
The main updates for this release are the following.
This release is recommended for all Excel-DNA add-ins. Projects should migrate to newer the SDK-style project files, whether targeting .NET Framework 4.x or .NET 6.
Excel-DNA v1.7.0 supports:
Support for newer .NET runtimes will follow in a future Excel-DNA version.
It is recommended that add-ins to be distributed outside a company, or that will run in a less controlled software environment with other add-ins, continue to target .NET Framework 4.x. This has the advantage of a stable runtime that need not be separately installed and serviced, and being able to load without interfering with other add-ins.
Add-ins targeting .NET 6 may be unexpectedly disabled by future add-ins targeting a newer version of .NET, or conversely might block other add-ins that target a newer version. Hence, some care should be taken where such add-ins are externally distributed for use as third-party add-ins in.
Excel-DNA add-in are most easily created by installing the 'ExcelDna.AddIn' package from NuGet.
An archive file containing the library outputs and the two main NuGet packages are attached to this GitHub Release as an alternative distribution option to the NuGet package sources.
The preferred support channel for Excel-DNA is the Excel-DNA Google Group. Direct corporate support agreements are also available, for those using Excel-DNA in a mission critical setting, or who would like easy access to direct support.
Excel-DNA is registered on GitHub Sponsors. All contributions are used to fund further development.
A big thank you to our donors, sponsors and corporate support customers. Your support is crucial in keeping this project alive and up-to-date.
Thanks to everyone who has participated by asking questions, contributing to discussions, submitting fixes to the repository, or helping spread the word about our library. A shout-out to Sagi Shahar for helping to consolidate the website and documentation fragments into one place.
A very special thanks goes to Sergey Vlasov for doing most of the development work in recent years. Sergey also creates a great family of Visual Studio extensions and tools worth checking out.
And finally, and most importantly, thank you to all the developers and Excel user who use Excel-DNA, whether it's just occasionally or every day. You are the reason this project exists.
Govert van Drimmelen
[email protected]
12 December 2023
Published by govert over 4 years ago
Excel-DNA version 1.1 implements workarounds for two recent changes in Excel behaviour:
ExcelRtdServer
, and streaming functions based on IExcelObservable
stopped updating after recent (early 2020) Excel updates.The update also introduces strong-naming of the Excel-DNA assemblies (thanks @augustoproiete).
You can find a full list of changes included in this release is on the v1.1 milestone.
Version 1.1 is intended to be the final version of Excel-DNA to support legacy .NET Framework (< 4.5) and Excel (< 2007) releases.
Please ask questions and provide feedback via the Excel-DNA Google group.
Published by govert over 5 years ago
Version 1.0 will be the final version to support legacy .NET Framework (< 4.0) and Excel (< 2007) releases.
The update includes a number of bug fixes as well as improvements to the build-time Visual Studio integration:
QueueAsMacro
reliabilityExcelDna.AddIn
NuGet package (now requires NuGet 2.5) (thanks to @augustoproiete)ExcelDnaUtil.Application
works in Protected View - try harder but don't cacheUnhandledExceptionHandler
for macros (ExcelCommands
) too.dna
file (thanks to @augustoproiete).pdb
files (thanks to @lanfeust69)Published by govert over 5 years ago
Version 1.0 will be the final version to support legacy .NET Framework (< 4.0) and Excel (< 2007) releases.
The update includes a number of bug fixes as well as improvements to the build-time Visual Studio integration:
QueueAsMacro
reliabilityExcelDna.AddIn
NuGet package (now requires NuGet 2.5) (thanks to @augustoproiete)ExcelDnaUtil.Application
works in Protected View - try harder but don't cacheUnhandledExceptionHandler
for macros (ExcelCommands
) too.dna
file (thanks to @augustoproiete).pdb
files (thanks to @lanfeust69)Published by govert over 7 years ago
Version 0.34 introduces a much improved build procedure for add-ins created using the NuGet package (thanks to a fantastic work by @augustoproiete !) This replaces the error-prone post-build steps we had with a custom build helper and allows easier build output customization.
Various bug fixes and smaller improvements are also included in this version:
ExplicitExports="false"
to NuGet .dna file templateProtectedViewWindow
EXCEL7
.ExcelAsyncUtil.Observe
re-open restart - broken by other fixes in the previous version. Add option to not restart.ExcelRtdServer.ConnectData
to be more careful about raising an update notice. Calls to Topic.UpdateNotify
during the ConnectData
overload are now always ignored. If the topic value is updated (through Topic.UpdateValue
) during ConnectData
, and the same value is returned from ConnectData
, then no spurious UpdateNotify
is raised. If the value returned from ConnectData
differs from Topic.Value, UpdateNotify
will still be raised.AccessViolation
exceptions to be caught under .NET 4.0 - change marshaling wrapper from DynamicMethod
to MethodBuilder
.QueueAsMacro
failure after paste live preview.AssemblyResolve
re-entrancy race condition.The easiest way to create an Excel-DNA add-in is by creating a class library project in Visual Studio and then installing the ExcelDna.AddIn
NuGet package.
Published by govert over 7 years ago
This is a release candidate for Excel-DNA v0.34.
Version 0.34 introduces a much improved build procedure for add-ins created using the NuGet package (thanks to a fantastic work by @augustoproiete !) This replaces the error-prone post-build steps we had with a custom build helper and allows easier build output customization.
Various bug fixes and smaller improvements are also included in this version:
ExplicitExports="false"
to NuGet .dna file templateProtectedViewWindow
ExcelAsyncUtil.Observe
re-open restart - broken by other fixes in the previous version. Add option to not restart.ExcelRtdServer.ConnectData
to be more careful about raising an update notice. Calls to Topic.UpdateNotify
during the ConnectData
overload are now always ignored. If the topic value is updated (through Topic.UpdateValue
) during ConnectData
, and the same value is returned from ConnectData
, then no spurious UpdateNotify
is raised. If the value returned from ConnectData
differs from Topic.Value, UpdateNotify
will still be raised.AccessViolation
exceptions to be caught under .NET 4.0 - change marshaling wrapper from DynamicMethod
to MethodBuilder
.QueueAsMacro
failure after paste live preview.The easiest way to test the new version is by installing or upgrading to the pre-release ExcelDna.AddIn 0.34.5-rc5
NuGet package. From the Package Manager Console: Install-Package -Pre ExcelDna.AddIn
Published by govert about 9 years ago
This is the public release of Excel-DNA v0.33.
ExcelDnaUtil.QueueAsMacro
(incorrect timer id tracking).Published by govert about 9 years ago
This release candidate update fixes a few issues in the NuGet installation script, and an unintended breaking change in the use of the XlCall
class.
Published by govert about 9 years ago
This is the first release candidate for Excel-DNA version v0.33.
Binaries are updated and included in the source tree under the Distribution\
directory.
A detailed change log can be found in Distribution\ChangeLog.txt
.
This version is also available as a (pre-release) NuGet package:
Install-Package ExcelDna.AddIn -Pre
Published by govert over 9 years ago
This is an updated Beta release of version 0.33. An initialization bug in Beta 2 that prevented the add-in from starting when ExcelDna.Integration.dll
was not present is fixed. All LogDisplay
logging is now channeled through the new TraceSource-based logging mechanism.
Binaries are updated and included in the source tree under the Distribution\ directory.
Published by govert over 9 years ago
This is an updated Beta release of version 0.33. The TraceSource-based logging is now used for all error handling the ExcelDna.Integration
. The internals of ExcelReference
has also been changed.
Published by govert over 9 years ago
This is a test release for the new diagnostic logging based on System.Diagnostics.Trace. In particular the warnings and errors logging for function registration have been improved.