News for hackers. Stuff that matters.

A comment on Advancing Excel as a programming language [audio]. Parent comment

Re:Advancing Excel as a programming language [audio] by aarondia on Wednesday May 05, 2021 @12:15PM (#27051860)
One example is 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.

[ Parent | on HN ]
Re:Advancing Excel as a programming language [audio] by ww520 on Wednesday May 05, 2021 @12:23PM (#27051954)
Yes. 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.
[ Parent | on HN ]
Re:Advancing Excel as a programming language [audio] by tinomaxgalvin on Thursday May 06, 2021 @03:39AM (#27060205)
The 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.
[ Parent | on HN ]
Re:Advancing Excel as a programming language [audio] by ww520 on Thursday May 06, 2021 @02:39PM (#27067453)
Good to know.
[ Parent | on HN ]