Viewing profile — pyxll

PyXLL (www.pyxll.com) is written using the Excel C API and that’s partly how it achieves its excellent performance. It’s not free software, but it ‘properly’ integrates Python into…

Jinx is a new product for writing Excel Add-Ins in Java: https://exceljava.com It works by embedding the JVM in Excel and exposing annotated Java (or Scala, Kotlin etc) methods to …

PyXLL embeds python, and so runs python in-process (that is, in the same process as Excel, without spawning a child process). PyXLL fully supports UDFs (user defined functions) in …

also http://www.pyxll.com if you want a solution that embeds python and doesn't use a COM server

with http://www.pyxll.com you can have functions that take and return pandas dataframes and series, see https://github.com/pyxll/pyxll-examples/blob/master/customty...

LibreOffice has python support http://api.libreoffice.org/examples/examples.html

If you want to call Python functions from Excel in the form of user defined functions, macros or menu functions (including macros bound to UI widgets and application events) you sh…