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
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.