4 ms·

I was looking for the 'secret' sauce used to get python being able to interact with Excel: http://showmedo.com/videotutorials/video?name=2190010&fromSeriesID=21

by kelvin0 12y 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&fromSeriesID=219 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?

jonknee 12y ago
The source is on GitHub... https://github.com/ZoomerAnalytics/xlwings https://github.com/ZoomerAnalytics/xlwings The magic you're looking for is here: https://github.com/ZoomerAnalytics/xlwings/blob/master/xlwings/xlwings.bas https://github.com/ZoomerAnalytics/xlwings/blob/master/xlwin... Surprisingly simple actually.
- kelvin0 12y ago
  I was expecting something a bit more complicated, but simplicity usually is the best way to go...
deleted 12y ago
[deleted]