3 ms·
I wish there was a Python excel.
by ant6n 6y ago
I wish there was a Python excel.
- saynotobloat 6y agohttps://openpyxl.readthedocs.io/en/stable/index.html https://openpyxl.readthedocs.io/en/stable/index.html
- Vaslo 6y agoNot that many features are applicable to Excel. I've tried these and eventually have to default back to VBA to do what I need.
- fartcannon 6y agoWith the uno library, you can directly script LibreOffice Calc with python. https://help.libreoffice.org/6.3/en-US/text/sbasic/python/main0000.html https://help.libreoffice.org/6.3/en-US/text/sbasic/python/ma... As a demonstration, I ran a ray tracing python script from Calc and it rendered to cells in the spreadsheet.
- ant6n 6y agoI mean, I'd like a spreadsheet software where the cell formulas are python.
- olav 6y agoJust yesterday I stumbled across https://pyspread.gitlab.io/ https://pyspread.gitlab.io/ after finding that coding Excel is a complete desaster from a software engineering point of view - no testing, no debugging, no version control, no structure. It must have costed humanity many billions in vain.
- Optimal_Persona 6y agoWhaddya mean no version control? What about CTRL + SHIFT + S every few minutes with incremental cryptic filename additions to USE_THIS_ONE_CopyofCopyof_VERY_IMPORTANT_myLatest_Edits_to_Copy_of(3)_DONT_DELETE.xlsx? ;-) But if you use Office 365 for file storage, there is actual version history for Office documents.
- ant6n 5y agoIf the version history isn’t named, then there is no version control, just versioning.
- 7thaccount 6y agoThere have been some tools before such as DataNitro, but they don't exist anymore. I think they still have several Python libraries out there, but yeah I wish Excel included Python support along with VBA.