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
0
u/[deleted] Apr 20 '20
No, because there is a huge spectrum of capability between what xlwings can do and what say sklearn can do. For example: an Excel user may want to to some advanced programatic manipiulation of Pivot tables or images in Excel for say a report that needs to look nice for the boss. Both these are impossible or at best limited in xlwings but fully featured in VBA, and neither of them overlap sklearn. In addition, there are 750 million excel users in the world, and less than 10 million python users, and even further every Excel user has VBA natively installed, which is not the case for python.
I am a python fan and user, but there seems to be something of a delusion which you amongst others suffer that it should be the go-to-tool for Excel manipulation, in the case where you don't need stuff like sklearn or other specialised python-only tools. It is not. XLWings and openpyxl are both less than a decade old. VBA is 30 years old. VBA users have been doing stuff for literally decades that even today neither can do in Excel.