News for hackers. Stuff that matters.
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.
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.
Re:Advancing Excel as a programming language [audio] by ww520 on Thursday May 06, 2021 @02:39PM (#27067453)
Good to know.