Call python code from VSTO excel addin

Question

I am working on an excel2007 plugin in VSTO and use VB to encode it. One of the elements in the plugin is a button, clicking on which should give a call to the python program, which will add some data to the current worksheet. I would like to know 1 How can I call a python function from VBA code 2 to pass the active workbook to this code?

Answer 1

you can use PyXLLto call the python function from Excel either as a worksheet function or as a macro that you can call from VBA. If you look at the documents xl_macroon the PyXLL website , you will find an example of how to do this.

Answer 2

You might also want to consider integrating Python and Excel through COM, as this has sufficient flexibility. See Managing Excel with Python on Windows .

For the Python add-in, loaded directly into Excel, I also posted a simple implementation at http://www.bnikolic.co.uk/expy/expy.html , which is free and source code.