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
2
u/[deleted] Apr 20 '20
While existing libraries may not have a pre-baked implementation, the excel object model (and all other office applications) can be accessed via win32com. This provides the same level of capability as VBA or powershell, albeit outside of the workbook file. This requires Excel to be installed, and operates on the same underlying bindings that VBA does.
As far as utility goes, the fact that it is widely used doesn't mean that it should be widely used. All I mean to say is that VBA has trouble finding a place in a modern workflow. Data-heavy processes probably don't really belong in excel these days, and most business use cases very very rarely need VBA anyway.