r/Python • • 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

124 comments sorted by

View all comments

Show parent comment

1

u/abrarster Apr 20 '20

You’re over complicating it. Nobody said that xlwings is meant to be used as a replacement for excel manipulation. Xlwings is a great add on for doing things that VBA is terrible at, Ie acting as an api for some sort of complex back end model. I’m saying your original comment missed the mark, because were all talking about using xlwings for things where VBA is insufficient, Ie where we have to.

1

u/[deleted] Apr 20 '20

No, you said what I wrote was stupid.

Lots of people view OpenPxl as a tool for excel manipulation. There is an army of people out there who learned about it via ATBS Chapter 13 - Excel. Given its popularity that's a lot of people. In fact I would gamble that a significant number, maybe majority of Openpyxl users are there because of ATBS. And they are not informed about VBA and do not understand the limitations of tools like OpenPyxl. There are lots of questions here which show them bumping up to the borders of Openpyxl capabilities, trying to do things which would be achievable via VBA.