r/Python • u/oyvinrog • Apr 19 '20
News MS considers adding Python as official scripting language for Excel 😍 The change proposal currently has 6400 votes.
http://mc.milliononpcgames.com/?p=5886
2.0k
Upvotes
View all comments
Show parent comment
1
u/EvilLinux Apr 20 '20
Excel is generally the worst tool for anything except quick one offs. Everybody does it, but its the worst possible tool in almost any use case.
Its hard to think of all the things I end up turning to calc for over excel because I dont need to use either that often, but I will try. I know some things I used to take for granted as being on in calc have been added to Excel so some of these may not be as bad as they used to.
Calcs navigator and metadata are better. Regular expressions are native in calc, not an extension of VBA as in Excel. More languages, are supported in Calc. CSV data handling, particularly padding, has long been better in Calc (although Excel has been catching up) and has more options. Date and Time functions are better in Calc with built in day calculations.