[IronPython] Creating Excel Add-in with Iron Python

[Seshadri Pillailokam Vijayaraghavan]

Couple of weeks back I wrote a Addin for VS that does something similar  to what you are describing. It was intended as a demo\sample on how to use the DLR Hosting API.

It is basically a simple addin for VS that routes all events to a python function defined in a '.py' file.   Take a look at this - http://blogs.msdn.com/seshadripv/archive/2008/07/17/dlr-hosting-sample-write-event-handlers-for-vs-in-ironpython.aspx. If you think this is along the lines of what you want to do, let me know. I also started writing a similar thing for excel but didn't go through with it. I could probably share that with you if you are interested.


From: users-bounces at lists.ironpython.com [mailto:users-bounces at lists.ironpython.com] On Behalf Of Todd Page
Sent: Friday, August 01, 2008 8:36 AM
To: users at lists.ironpython.com
Subject: [IronPython] Creating Excel Add-in with Iron Python

Hi guys,

Just starting to get into IronPython and have been poking around for the last few days; but I'm hoping someone can help. Basically, I want to take some python (IronPython) code, compile it to a dll (or xll?) and have it function like an add-in for excel. So, I could code functions in python and just call them as worksheet functions in excel. This is greatly preferable to writing VBA!!

Can anyone point me in the right direction? After days of googling all I seem to have is 10-12 open tabs and still no concrete answer. Any help is appreciated, thanks!

twp
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/ironpython-users/attachments/20080801/afd09da8/attachment.html>