Excel-DNA Version 0.30

Rating:        Based on 11 ratings
Reviewed:  10 reviews
Downloads: 13654
Change Set: 77876
Released: Dec 12, 2012
Updated: Dec 11, 2012 by govert
Dev status: Stable Help Icon

Recommended Download

Application ExcelDna-0.30.zip
application, 1222K, uploaded Dec 11, 2012 - 13654 downloads

Release Notes

Excel-DNA Version 0.30 implements support for RTD-based asynchronous worksheet functions based on a thread-safe RTD base class - ExcelRtdServer. The asynchronous support is designed to (optionally) integrate with the .NET 4.0 Task-based operations, as well as the Reactive Extensions library, allowing IObservables to be exposed as 'live' worksheet UDFs - (thus 'RxExcel').

Various bug fixes have also accumulated over the last 18 months, and are collected in this release.

As always, I greatly appreciate any feedback on this version, and on Excel-DNA in general. Any comments or questions are welcome on the Google group or by contacting me directly.

Govert

Complete change list

  • Fixed LoadComAddIn error when using a direct ExcelComAddIn-derived class.
  • Fixed (Ribbon Helper) display in ribbon tooltips.
  • Fixed RTD / array formula activation bug.
  • Fixed IsMacroType=true reference argument sheet error (ExcelReference pointed to active sheet instead of current sheet).
  • Fixed array marshaling pointer manipulation concern under 64-bit Excel.
  • Fixed check for derived attributes too - for backward compatibility with v. 0.25.
  • Fixed assembly multiple-loading problem for packed assemblies.
  • Fixed persistent COM registration (Regsv32.exe / ComServer.DllRegisterServer) to allow HKCR registration whenever possible (for UAC elevation issue).
  • Fixed Excel version check when COM / RTD Server loads before add-in is loaded - ribbon would not load.
  • Fixed IntPtr OverflowException in high-memory 32-bit processes.
  • Fixed custom task panes UserControl activation - do HKCR registration whenever possible (for UAC elevation issue).
  • Fixed double[0,1] array marshaling memory allocation error with potential access violation.
  • Allow abstract base classes in ExcelRibbon class hierarchy. Now loads the first concrete descendent of ExcelRibbon as the ribbon handler.
  • Remove Obsolete class ExcelDna.Integration.Excel. (Use ExcelDnaUtil instead.) Allows smooth XlCall usage.
  • Allow external SourceItem packing.
  • Add ExcelAsyncUtil for async macro calls.
  • Add thread-safe RTD server base class ExcelRtdServer.
  • Add async function helper as ExcelAsyncUtil.Run.
  • Add support for Reactive Extensions via RTD via ExcelAsyncUtil.Observe and related interfaces.
  • Change ExcelRibbon and ComAddIn loading to use declared ProgId and Guid if both attributes are present. Fixed Ribbon QAT issue.
  • Revisit caching of Application object.
  • Rename ExcelDna.Integration.Integration to ExcelDna.Integration.ExcelIntegration.
  • Implement macro shortcuts (from ExcelCommand attributes).
  • Changed re-open via File->Open to do full AppDomain unload and add-in reload.

Reviews for this release

     
Excel DNA is a must-have for .NET engineers developing Excel add-ins. The software design and implementation is of high quality and comprehensive. Organizations in various industries depend on and use this library in Production environments. Furthermore, the community support is responsive and robust.
by bishrtabbaa on Dec 5, 2013 at 2:12 PM
     
This has permited us to level the performance of our existing VBA UFD. Now with acess to the .Net framwork and multithread capability, the possibility seem infinite.
by maseyer on Nov 16, 2013 at 11:03 AM
     
Very easy to use. Congratulations.
by valterleimv on Oct 17, 2013 at 5:56 PM
     
It just works. Simple, powerful and effective. Top marks.
by keithsthomas on Oct 9, 2013 at 7:40 PM
     
I would thank Govert for his wonderful work on this. This library saves us loads of work! Awesome. God Bless!
by SathishRaju on Sep 14, 2013 at 10:28 PM
     
Excel-DNA is nothing short of GROUNDBREAKING for Excel development! Very rarely am I ever excited about programming and even more so I am skeptical of open source, but simply put, if your current Excel application is like astronaut Steve Austin then Excel-DNA can make it like The Six Million Dollar Man: We can rebuild it. We have the technology. Better than it was before… better… stronger… faster!
by AltonXL on Aug 12, 2013 at 11:07 PM
     
excellent work and easy to use!
by psommer on Jun 13, 2013 at 1:11 PM
     
really useful!
by cordts on May 23, 2013 at 6:58 AM
     
pretty good job. Simplifies a lot of work.
by SlimAyeche on Apr 9, 2013 at 11:50 AM
     
This version 0.30 is very stable and there are no known regression when used with my software.
by jmpir on Feb 7, 2013 at 7:01 AM