Tag Archives: Excel

Tutorial: COM server support for VBA integration

Functions and macros created in an Excel-DNA add-in can be called directly from Excel VBA by using Application.Run(…). However, .NET also supports creating rich object models that are exported as COM libraries, which can be Tools->Referenced in VBA. Excel-DNA has … Continue reading

Posted in Uncategorized | Tagged , , , , , , ,

Streaming real-time data to Excel

Gert-Jan van der Kamp has posted a very nice end-to-end example on CodeProject, showing how to create a WCF service and Excel-DNA add-in to stream real-time data into Excel. The example uses to use the Reactive Extensions support in Excel-DNA … Continue reading

Posted in Uncategorized | Tagged , , ,

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

Resizing Excel UDF result arrays

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

Offloading UDF computations to a Windows HPC cluster from Excel 2010

Excel 2010 introduced support for offloading UDF computations to a compute cluster. The Excel blog talks about it http://blogs.msdn.com/b/excel/archive/2010/02/12/offloading-udf-s-to-a-windows-hpc-cluster.aspx, and there are some nice pictures on this TechNet article: http://technet.microsoft.com/en-us/library/ff877825(WS.10).aspx. Excel-DNA now supports marking functions as cluster-safe, and I have updated the … Continue reading

Posted in Features | Tagged , , , ,