Category Archives: Samples

Caching and Asynchronous Excel UDFs

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 , , , ,

Async and event-streaming Excel UDFs with F#

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

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

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 , , , ,