Comment on Use Python in Excel without add-insComments−kelvin011yI 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?−jonknee11yThe source is on GitHub...https://github.com/ZoomerAnalytics/xlwingsThe magic you're looking for is here:https://github.com/ZoomerAnalytics/xlwings/blob/master/xlwin...Surprisingly simple actually.−kelvin011yI was expecting something a bit more complicated, but simplicity usually is the best way to go...
Comments
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?
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...