This project has moved. For the latest updates, please go here.

Excel-DNA Version 0.29

Rating:        Based on 4 ratings
Reviewed:  3 reviews
Downloads: 10414
Change Set: 67101
Released: May 28, 2011
Updated: Jun 1, 2011 by govert
Dev status: Stable Help Icon

Recommended Download

Application ExcelDna-0.29.zip
application, 666K, uploaded May 28, 2011 - 10414 downloads

Release Notes

Excel-DNA version 0.29 adds support for a number of specialized Excel features. The 64-bit version of Excel 2010 is fully supported, registration-free Custom Task Panes can be created under Excel 2007 and later, direct COM server integration can improve integration with legacy VBA code, and macros with parameters are registered. In addition, there are some features to improve the development and debugging workflow, and a few minor bugfixes.

More information about the new features will be posted on the Excel-DNA website in the coming weeks. Any comments or questions are welcome on the Google group or by contacting me directly.

As always, I greatly appreciate any feedback on this version, and on Excel-DNA in general.

Govert

Complete change list

  • BREAKING CHANGE! Changed SheetId in the ExcelReference type to an IntPtr for 64-bit compatibility.
  • Changed initialization - only create sandboxed AppDomain under .NET 4 (or if explicitly requested with CreateSandboxedAppDomain='true' attribute on DnaLibrary tag in .dna file).
  • Fixed memory leak when getting SheetId for ExcelReference parameters.
  • Fixed Ribbon RunTagMacro when no Workbook open.
  • Fixed Missing/Empty marshaling in XlCall.Excel calls under Excel 2003 and below.
  • Added support for the 64-bit version of Excel 2010 with the .Net 4 runtime.
  • Added Cluster-safe function support for Excel 2010 HPC Cluster Connector - mark functions as IsClusterSafe=true.
  • Added CustomTaskPane support and sample.
  • Added COM server support for RTD servers and other ComVisible classes. Mark ExternalLibraries and Projects as ComServer="true" in the .dna file. Supports Regsvr32 registration or by calling ComServer.DllRegisterServer. Allows direct RTD and VBA object instantiation. Includes TypeLib registration and packing support.
  • Added support for macros with parameters.
  • Added ArrayResizer sample.
  • Added C# 4 dynamic type sample.
  • Added Path attribute to SourceItem tag to allow external source.
  • Added LoadFromBytes attribute to ExternalLibrary tag to prevent locking of .dll.
  • Added /O output path option to ExcelDnaPack.
  • Added 'before' option to CommandBars xml.
  • Added Int64 support for parameters and return values.

Reviews for this release

     
Outstanding. Made so many Excel/.NET integration tasks quite simple. Thank you!
by txjmb on Nov 30, 2012 at 7:43 PM
     
This is a wonderful (and stable!) project that should be receiving far more attention than it has.
by mwolfe02 on Oct 22, 2012 at 6:52 PM
     
Fantastic toolset for creating Excel AddIn's from .NET. The support provided by the author is also first class.
by aquiesce on Sep 1, 2012 at 10:03 AM