I'm on the hunt for a spreadsheet application that lets me use Python scripting. I've come across a few options like Python in Excel (which is still experimental), xlwings, PySheets, and Quadratic. Here's what I'm looking for in a tool:
- It should be free for personal use.
- I want to be able to call Python functions directly from the spreadsheet cells. Ideally, I'd love the functionality to write my own Python functions that automatically update when other cells do, or that can be triggered by a button.
- It would be great if I can run it from my local Python environment, or if it has robust features in an online format.
- I want to access libraries like NumPy, fetch data online, and so on.
I'm comfortable working with NumPy and Matplotlib but I'd prefer a spreadsheet interface for tasks like personal finance tracking while still leveraging my Python skills. I'm currently considering xlwings, but I'm open to other suggestions before making a final decision.
4 Answers
Have you checked out Grist? It has a clean interface and integrates well with Python. However, it seems that it can only map Python functions to entire columns rather than individual cells, which might be a limitation if you're looking for more granular control.
Pour one out for ResolverOne; it was a game changer back in the day for Python integrations with spreadsheets!
LibreOffice has had some Python integration for a while now. It's pretty robust and can be a solid option if you prefer open-source software.
I’ve been using xlwings and it’s fantastic! You can write Python functions and call them from Excel like regular formulas. Definitely worth a shot if you haven't tried it yet.
Yeah, I looked into Grist too. It does seem cool but if it can't handle specific ranges, that's a downside for certain tasks.