4 ms·
One example is https://www.pyxll.com/ https://www.pyxll.com/ which lets you write Excel Add-ins using Python. I've never used it myself, but I have tried to us
by aarondia 5y ago
One example is https://www.pyxll.com/ https://www.pyxll.com/ which lets you write Excel Add-ins using Python.
I've never used it myself, but I have tried to use the Excel JS API, and it was quite a pain.
- ww520 5y agoYes. I believe the way Excel hosting other languages inside it as scripting addon is via the COM Automation Server interface again. The other language needs to implement as a COM Automaton Server. Excel then instantiates the other language's Automation Server as an embedded COM object and calls its interface, which can call the functions implemented with the language.
- tinomaxgalvin 5y agoThe approach used by pyxll is higher performance. It uses the Excel C API. Excel add-ons can be written as native DLLs known as XLLs.
- ww520 5y agoGood to know.