Unpopular opinion time: but give me a csv and a python script any day over excel.
I can’t count the hours I spend cleaning up and debugging xlsx files from customers that were completely unusable due to excels automatic data type feature.
Python in Excel requires Internet access because calculations run on remote servers in the Microsoft Cloud. The calculations are not run by your local Excel application.
Unpopular opinion time: but give me a csv and a python script any day over excel.
I can’t count the hours I spend cleaning up and debugging xlsx files from customers that were completely unusable due to excels automatic data type feature.
You can turn that off now.
What do Excel and Incels have in common?
They assume everything is a date.
How about an Excel with Python scripting? That would be awesome.
Not sure if you’re joking, but that’s a thing. You can just insert python scripts into a cell and have their return values be the cell value.
From: https://support.microsoft.com/en-us/office/troubleshoot-python-in-excel-errors-7736520d-47ef-43a8-b640-d826afb63249
… so?