Author Archives: Govert

Excel-DNA 0.32 Released

I’ve posted a final release of Excel-DNA version 0.32 to CodePlex (https://exceldna.codeplex.com/releases/view/119190) and the NuGet package repository (https://www.nuget.org/packages/Excel-DNA). Excel-DNA 0.32 consolidates a large number of bug fixes and improvements that have accumulated over the last year. In particular, a number … Continue reading

Advertisement

Posted in Release | Comments Off on Excel-DNA 0.32 Released

Excel-DNA 0.32 – Breaking changes to integer and boolean parameter handling

Excel-DNA version 0.32 introduces some changes in the parameter conversions applied to integer and boolean parameters. These changes improve compatibility with VBA, and make it easier to provide a consistent implementation when the conversion needs to be explicitly implemented, as for … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Excel-DNA 0.32 – Breaking changes to integer and boolean parameter handling

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 , , , , , , , | Comments Off on Tutorial: COM server support for VBA integration

Excel-DNA 0.32 Release Candidate

I have posted to CodePlex (https://exceldna.codeplex.com/releases/view/119190) and the NuGet package manager (https://www.nuget.org/packages/Excel-DNA/0.32.0-rc1) a release candidate of the next Excel-DNA version.I hope to make a final release in the next few weeks, once I’ve had confirmation that this version works well … Continue reading

Posted in Uncategorized | Comments Off on Excel-DNA 0.32 Release Candidate

Getting started with F# and Excel-DNA in finance

Bram Jochems has written a friendly  ‘Getting Started’ post, discussing how to use F# with Excel-DNA in a finance context. His add-in with various F# / Excel-DNA helper utilities, and a bunch of quantitative finance-related UDFs, including option pricing function and … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on Getting started with F# and Excel-DNA in finance

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 , , , | Comments Off on Streaming real-time data to Excel

F# and R in Excel

Natallie Baikevich has posted some very pretty examples of using F# with Excel-DNA. One function uses the R type provider to easily expose a feature from an R package as an UDF in Excel. Have a look at the write-up, and … Continue reading

Posted in Uncategorized | Tagged , | Comments Off on F# and R in Excel

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 , , , , | Comments Off on Caching and Asynchronous Excel UDFs

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

Excel-DNA NuGet Package Updated

I’ve updated and improved the Excel-DNA NuGet package. (NuGet is the Visual Studio package manager that makes it easy to download and install external libraries into your projects.) To turn your Class Library project into an Excel add-in, just open Tools … Continue reading

Posted in Uncategorized | Tagged | Comments Off on Excel-DNA NuGet Package Updated