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.