4 ms·
Dear Excel team, Take a look at the top three results for "excel python" on bing.com for some great ideas on how to incorporate python into excel. --- 1.) ht
by _e 9y ago
Dear Excel team,
Take a look at the top three results for "excel python" on bing.com for some great ideas on how to incorporate python into excel.
---
1.) https://www.python-excel.org https://www.python-excel.org
2.) https://www.pyxll.com/ https://www.pyxll.com/
3.) https://www.xlwings.org/ https://www.xlwings.org/
- smortaz 9y agoThank you - all awesome tools. Kudos to the devs behind these bridges. We did one ourselves, but better ones have come along since then: https://www.youtube.com/watch?v=Gu31s7kXPOg https://www.youtube.com/watch?v=Gu31s7kXPOg
- askvictor 9y agoThere is also pyspread as a full spreadsheet implementation using and for Python: https://manns.github.io/pyspread/ https://manns.github.io/pyspread/
- vanderZwan 9y ago> Pyspread expects Python expressions in its grid cells, which makes a spreadsheet specific language obsolete. Each cell returns a Python object that can be accessed from other cells. These objects can represent anything including lists or matrices. Huh, on the one hand sounds like a such a simple way to deal with it that I can have trouble imagining a more elegant approach. On the other hand, does it still respect the ways that Excel updates cells? Sicne that kind of requires immutability I think.
- cheapsteak 9y ago> https://www.python-excel.org/ https://www.python-excel.org/ The https link doesn't seem to work, try this: http://www.python-excel.org/ http://www.python-excel.org/
- throwaway7645 9y agoAlso DataNitro
- m_mueller 9y agoHaha, I love the little jab at Microsoft's NIH syndrome by suggesting bing search results - seems though that by looking at Python they're slowly getting over that.