Python as an Excel scripting language
Let us do scripting with Python! Yay! Not only as an alternative to VBA, but also as an alternative to field functions (=SUM(A1:A2))
Thank you to all those participated in our survey. What an amazing number of responses, many of them with very deep content. We’re processing the over ten thousand responses(!), and already appreciate the time so many of you took to answer with passion and experience.
Please know this survey is used to help influence various topics – both on Python as well as other related topics that the comments started to bleed into. Given the passion, I want to be clear this remains an area of exploration for us, without any specific timeline.
We’ll provide updates as we progress on this feature request.
Lead Program Manager
Mark Ransom commented
I remember doing VBA years ago to connect an access database to Active Directory. I'd love to be able to write Python to interact directly with Excel spreadsheets.
Kyle Benzo commented
Would love baseline support for python in Excel! Would make my job sharing scripts on company machines a lot easier.
Ryan Butters commented
This is an excellent idea. MS, please carry this forward.
Evan Parker commented
Lucas Schwarz commented
I prefer Python to R; not all desire for Python is born of statistical need and R is a very focused on statistics.
I agree with Xiaolun Cheng - Python would be the best possible replacement for VBA. I love R but for scripting Python is the way to go.
Pierre McCann commented
Having R would be amazing. To respond to another comment about how every vote on this thread was for Python is not exactly accurate - I was just voting to use something besides VBA. I'm more comfortable with R than with Python so, if it were between the two, I would want R.
Xiaolun Cheng commented
I think using Python would be most in line with VBA's function - to provide quick scripting and automations. R is perfect in the sense for statistical use, but scripting-wise I think Python makes more sense. On a side note - it would be really useful for us if more statistical functions are integrated into native Excel formulas/functions, rather than packages.
Yes, I think as the title says 'Python', each and every vote is for python and not after R specifically
Abdullah Tanveer Rahman commented
python(and R) is a already dominating the data science field. It would be great if Excel decides to join with python. Lot of existing projects will be able integrate.
I have a feeling powershell would come in first...
That's a great idea
Nicholas Johnson commented
R would be nice as well...
Have a look at PyXll (https://www.pyxll.com/) - it allows you to make worksheet functions with Python, and much more.