Tag Archives: Async

Caching and Asynchronous Excel UDFs

Posted on 2 April 2013 by Govert

This sample shows how the result of an Excel-DNA async UDF call can be cached using the .NET 4 MemoryCache class. PS: Apparently there is a bug in the memory management of the .NET MemoryCache class. See the StackOverflow discussion and the … Continue reading →

Posted in Samples | Tagged , , , , | Comments Off on Caching and Asynchronous Excel UDFs

Async and event-streaming Excel UDFs with F#

Posted on 26 March 2013 by Govert

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 , , , | Comments Off on Async and event-streaming Excel UDFs with F#

Resizing Excel UDF result arrays

Posted on 30 January 2011 by Govert

Update (21 June 2017): The most up-to-date version of the ArrayResizer utility can be found here: https://github.com/Excel-DNA/ExcelDna/blob/master/Distribution/Samples/ArrayResizer.dna 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 … Continue reading →

Posted in Samples | Tagged , , , , | Comments Off on Resizing Excel UDF result arrays