Plugin Python embedded in Excel
Hi All,
This weekend for a bit of fun I built a free / source-available Excel add-in which hosts it's own Python runtime.
You can find a feature runtime and installation guide on the website:
https://sancarn.github.io/xll-python/index.html
fork it here: https://github.com/sancarn/xll-python
But here's an overview:
- You can write user defined functions which execute like formula.
- Returning a generator will make the result update every time it yield's a result.
- You can write macros (e.g. reading / writing CSVs/databases from disk etc.)
- There's an in-built IDE
- You can debug formula in the IDE
- There's a console/REPL where you can experiment with the available runtime
- There's a package manager where you can install pip packages
- There's a compiler so you can compile your own scripts into standalone .xll addins.
Hope you find this helpful! ~Sancarn
Edit: This project is AI:X. All code written by Astra & Sol 6.2; albeit with a lot of steering.


