Excelbind is a free open-source Excel Add-in, that expose your python code to Excel users in an easy and userfriendly way.
Excelbind uses the Excel xll api together with an embedded python interpreter, so your python code runs within the Excel process. This means that the overhead of calling a python function is just a few nano seconds.
You can both expose already existing python functions in Excel as well as run python code directly from Excel.
To expose a python function in Excel as a user-defined function (UDFs) just use the excelbind function decorator:
import excelbind
@excelbind.function
def my_simple_python_function(x: float, y: float) -> float:
return x + y
To write python code directly inside Excel just use the execute_python function:
=execute_python("return arg1 + arg2", A1, B1)
The Excelbind documentation can be found at https://excelbind.readthedocs.io/en/latest/
See the TODO file.
Rune Ljungmann
The project mainly piggybacks on two other projects:
- pybind11, which provides a modern C++ api towards python
- xll12, which provides a modern C++ wrapper around the xll api and makes it easy to build Excel Add-ins.
Excelbind basically ties these two together to expose python to Excel users.
A big source of inspiration is the ExcelDNA project. A very mature project, which provides Excel xll bindings for C#. Especially the semi-dynamic exposure of functions in the dll api using a thunks table is inspired by the way this is handled in ExcelDNA.
Excelbind also uses:
- A headers only version of inih for parsing ini files
- The date library by Howard Hinnant.
There are at least two other projects solving a similar problem to Excelbind: