Hacker News new | ask | show | jobs
by kelvin0 4282 days ago
I was looking for the 'secret' sauce used to get python being able to interact with Excel: http://showmedo.com/videotutorials/video?name=2190010&fromSe...

However, I still haven't looked how the reverse is done (by xlwings.bas in Excel). Is it that XLWings also implments a COM server from which VBA can run Python?

1 comments

The source is on GitHub...

https://github.com/ZoomerAnalytics/xlwings

The magic you're looking for is here:

https://github.com/ZoomerAnalytics/xlwings/blob/master/xlwin...

Surprisingly simple actually.

I was expecting something a bit more complicated, but simplicity usually is the best way to go...