r/excel • u/sancarn 8 • 23h ago
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.
10
Upvotes
2
u/Successful_Safe_1440 16h ago
id like to learn more
2
u/Fallingice2 12h ago •
Sounds like a security.risk
2
u/Think-Excitement-851 35m ago
Why? Excel has a functional language
4
u/Double_Cost4865 1 21h ago
I couldn't find any AI disclaimers. How much was AI involved in this?
1
u/decimalturn 32m ago
In terms of portability, how does it work? What's the minimal setup process someone has to do on their computer if I send them an .xlsm file that I created using user-defined functions with xll-python?