Prompted by a thread at The Wilmott Forums that linked here, I was prompted to take a look at XLW- A Wrapper for the Excel API.  This is what they say about themselves:

“XLW is an open source application that wraps the Excel C API in simple C++, C# or VB.NET interfaces which you can use to customize Excel with your own worksheet functions and menu items.

XLW developers include Financial Engineering practitioners with extensive experience of developing quantitative analytics in the finance industry including Mark Joshi the author of The Concepts and Practice of Mathematical Finance and C++ Design Patterns and Derivatives Pricing.”

I have yet to try it, so this isn’t a recommendation, but it does look interesting.

The Wilmott Forum thread is also worth a detailed read for different opinions on the best way to link Excel to compiled code.

Edit 14 Apr 2011:

Found via: http://chriscavanagh.wordpress.com/2008/04/13/excel-add-ins-in-c/

Moving from an Excel xla add-in to a C# add-in – a detailed account of the trials and tribulations of moving from an xla add-in to C#.  Not directly related to XLW, but well worth a read for anyone contemplating the same process.

This entry was posted in Excel, Link to dll and tagged , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.