Just yesterday I stumbled across 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.
Whaddya 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.
With the uno library, you can directly script LibreOffice Calc with python. 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.
I mean, I'd like a spreadsheet software where the cell formulas are python.
Just yesterday I stumbled across 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.
Whaddya 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.
If the version history isn’t named, then there is no version control, just versioning.
There 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.
https://openpyxl.readthedocs.io/en/stable/index.html
Not that many features are applicable to Excel. I've tried these and eventually have to default back to VBA to do what I need.