Soon Python will rule it all as the most widely adopted language
Until Excel can run Python locally, I doubt it.
Microsoft is bringing Python to Excel
21–30 of 455 posts
Re: Microsoft is bringing Python to Excel
#22》Python calculations run in Microsoft’s Cloud No thanks!
That caught my attention too! I'm curious why they would choose this model.
Probably because Excel runs in a web browser nowadays and they want to avoid creating a separate way of running Python locally for a locally installed copy of Excel.
Maybe they will in the future, but it makes sense to start with the approach that will work in both web and local installs.
Re: Microsoft is bringing Python to Excel
#23》Python calculations run in Microsoft’s Cloud No thanks!
That caught my attention too! I'm curious why they would choose this model.
Re: Microsoft is bringing Python to Excel
#24Wait just a moment. Libreoffice had python for years, but nobody cared and instead complained about needing 100% compatible VBA for "real work". Where are those people now?
Re: Microsoft is bringing Python to Excel
#25Off topic but why can’t we all go back to office 97?
It basically does all the same stuff and it would be lightning fast on modern machines. You don’t even need internet to use it.
Re: Microsoft is bringing Python to Excel
#26》Python calculations run in Microsoft’s Cloud No thanks!
That caught my attention too! I'm curious why they would choose this model.
A lot of people who use excel heavily are not really “programmers” and don’t have strong fundamentals or an appetite to manage their own software stack. This also simplifies development on MS end by only needing to validate a single python version.
Re: Microsoft is bringing Python to Excel
#27Wait just a moment. Libreoffice had python for years, but nobody cared and instead complained about needing 100% compatible VBA for "real work". Where are those people now?
finding another straw-man?
Re: Microsoft is bringing Python to Excel
#28I'm a developer. People have often come to me with Excel sheets that were really slow because it was just too much for Excel. Almost all of the times IMHO a specific solution should have been developed for it. I'm curious to see if this makes it better or actually worse.
Re: Microsoft is bringing Python to Excel
#29》Python calculations run in Microsoft’s Cloud No thanks!
That caught my attention too! I'm curious why they would choose this model.
Easier to debug a backend than clients code, single implementation, faster updates, and performance not limited by device.
At the cost of privacy. Consider msft could sell this to you but they chose to let you borrow it instead.
Re: Microsoft is bringing Python to Excel
#30I hope this is the start of a wholesale python replacement for VBA. Python has turned into what VBA always tried to be: A ubiquitous language for data and scripting (among other things).
Excel would be well served by replacing VBA with either JS or python because of their ecosystems and high levels of adoption. Python is the better choice because data analysts are more likely to be familiar with it.