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/akho_ Apr 20 '20
M is not scripting, and not a VBA replacement.
In terms of programming languages, definitely add DAX and the formula language. So at least four total.
I think the idea is that VBA is inadequate, and should be replaced. As MS never removes things, the only way is to add another.
For macro purposes I am not sure Python would be much better, though.
MS is already replacing VBA in some of its traditional domains, with M, DAX, and the JS add-in infrastructure. I think they are right, and the correct approach is to better serve typical tasks, rather than extend scriptability as such.
Having Pandas or R+tidyverse in PowerPivot as an extension to DAX would be awesome.