An absolute no-brainer. Python is the new BASIC - very popular with people who have to program to do their work but aren't programmers. It's an excellent choice for a spreadsheet.
Excel team considering Python as scripting language: asking for feedback
11–20 of 280 posts
Re: Excel team considering Python as scripting language: asking for feedback
#12An absolute no-brainer. Python is the new BASIC - very popular with people who have to program to do their work but aren't programmers. It's an excellent choice for a spreadsheet.
>aren't programmers
Also extremely popular with people who are programmers and need to do things.
Sorry, this is a frustration of mine lately. Python is a fantastic introductory language. It's also a fantastic general purpose language.
Newbies get turned off of it because it feels too easy, and they know that "real" programming is supposed to be hard.
Re: Excel team considering Python as scripting language: asking for feedback
#13Clickable Link: https://excel.uservoice.com/forums/304921-excel-for-windows-... [disclaimer+bias: on Python team @ msft & would love to see this happen!]
> @ msft Well, I guess that explains why you care about Office in 2017.
That and the fact that the vast majority of companies use Office...
Re: Excel team considering Python as scripting language: asking for feedback
#14Clickable Link: https://excel.uservoice.com/forums/304921-excel-for-windows-... [disclaimer+bias: on Python team @ msft & would love to see this happen!]
So, would this imply numpy and scipy support in Python for Excel? How about support for Excel worksheets within Jupyter notebooks?
Re: Excel team considering Python as scripting language: asking for feedback
#15You can already do this with xlrd and xlwt.
Re: Excel team considering Python as scripting language: asking for feedback
#16An absolute no-brainer. Python is the new BASIC - very popular with people who have to program to do their work but aren't programmers. It's an excellent choice for a spreadsheet.
[deleted]
Re: Excel team considering Python as scripting language: asking for feedback
#17An absolute no-brainer. Python is the new BASIC - very popular with people who have to program to do their work but aren't programmers. It's an excellent choice for a spreadsheet.
>aren't programmers Also extremely popular with people who are programmers and need to do things. Sorry, this is a frustration of mine lately. Python is a fantastic introductory language. It's also a fantastic general purpose language. Newbies get turned off of it because it feels too easy, and they know that "real" programming is supposed to be hard.
I disagree.
Python is great for scripting and for small projects, but I believe strong, static typing is an essential feature for large scale projects. I wouldn't want to use Python for anything that's predicted to end up with more than a couple thousand lines of code.
Re: Excel team considering Python as scripting language: asking for feedback
#18Dear Excel team, Take a look at the top three results for "excel python" on bing.com for some great ideas on how to incorporate python into excel. --- 1.) https://www.python-excel.org 2.) https://www.pyxll.com/ 3.) https://www.xlwings.org/
There is also pyspread as a full spreadsheet implementation using and for Python: https://manns.github.io/pyspread/
Re: Excel team considering Python as scripting language: asking for feedback
#19please do that
Re: Excel team considering Python as scripting language: asking for feedback
#20So when I google how to do something in Python I will have to comb through solutions specific to v2, v3 and now also Excel? ;) Aside from that it sounds like a cool idea.
[deleted]