Category Archives: Samples

Caching and Asynchronous Excel UDFs

Posted on 2 April 2013 by

This sample shows how the result of an Excel-DNA async UDF call can be cached using the .NET 4 MemoryCache class. <DnaLibrary Name=”CachedAsyncSample” RuntimeVersion=”v4.0″ Language=”C#”> <Reference Name=”System.Runtime.Caching” /> <![CDATA[ using System; using System.Threading; using System.Runtime.Caching; using ExcelDna.Integration; public static class … Continue reading →

Posted in Samples | Tagged , , , ,

Async and event-streaming Excel UDFs with F#

Posted on 26 March 2013 by

There have been a some recent posts mentioning the asynchronous and reactive programming features in F#. Since Excel-DNA 0.30 added support for creating async and IObservable-based real-time data functions, I’d like to show how these F# features can be nicely … Continue reading →

Posted in Features, Samples | Tagged , , ,

Excel VBA to VB.NET with Excel-DNA and NetOffice

Posted on 30 January 2012 by

Excel-DNA is a great library to help ease the path from Excel VBA to VB.NET. Last year another part of the puzzle fell in place: I discovered NetOffice, a version-independent set of Office interop assemblies put together by Sebastian Lange. By … Continue reading →

Posted in Samples

Resizing Excel UDF result arrays

Posted on 30 January 2011 by

Update: To work correctly under Excel 2000/2002/2003, this sample requires at least version 0.29.0.12 of Excel-DNA. A common question on the Excel-DNA group is how to automatically resize the results of an array formula. The most well-know appearance of this … Continue reading →

Posted in Samples | Tagged , , , ,