520
Microsoft announces Python formulas in Excel... which have to get sent to the cloud
(techcommunity.microsoft.com)
This is a most excellent place for technology news and articles.
Not everyone has an opportunity to work with Python in their work environment. I'm on the "business" side of the company, capable of doing most of programming stuff myself (Python, C#, SQL, etc.), whereas only "IT" people can work with the proper compileable code. And I'm left out working with VBA macros, or ask IT to write a script for me, which will take 1 year to develop. This change now will improve my local productivity for sure.
This issue isn't about authoring the script, is about why it needs to execute on the cloud rather locally.
Fair point, maybe I replied to a wrong comment. Nonetheless, I've seen comments saying "just use native Python". Not everyone can do that.
This happened in my old place - also on the business side. Asked for python, got it, then had it immediately removed because of security risks.
I told the head that I could still access tables and shit via excel if I wanted so what does it matter? He didn't realise this, and asked that I told no-one else it could be done. FFS.