Microsoft is adding the Python programming language to Microsoft Excel, allowing users to create powerful functions for analyzing and manipulating data.
The public preview of the feature is now available to Microsoft 365 Insiders in the Beta channel, with the goal to ultimately roll out the feature to Excel for Windows in 16.0.16818.2000.
However, even if you join the Microsoft 365 Insiders Beta channel to test the new feature, there is no guarantee that Python in Excel will be available, as Microsoft is rolling it out slowly to test the feature.
Python in Excel
The new Python in Excel feature brings a new ‘PY’ function that allows users to embed Python code directly in a cell to be executed like any macro or regular Excel function.
However, instead of running the Python scripts locally, Excel will execute the code in the cloud using a hypervisor-isolated container on Azure Container Instances. Microsoft says this container environment will include Python and a curated set of Anaconda libraries to prevent security issues.
These libraries include the data visualization and analysis tool ‘pandas’ and the visualization tool ‘Matplotlib.’
As the Python scripts will run in an isolated container, they will not have access to any local resources, including the local network, computer, files, and a Microsoft 365 authentication token.
To embed a Python script in Excel, users will use the =PY() function to open a text area where they can enter the Python code they wish to execute.
The code is then executed in the cloud container, and the results are sent back and displayed in the worksheet. Microsoft says this is all done anonymously so that your Python code is not linked back to a particular user.
“Python in Excel makes it possible to natively combine Python and Excel analytics within the same workbook - with no setup required,” Microsoft explains in an announcement.
“With Python in Excel, you can type Python directly into a cell, the Python calculations run in the Microsoft Cloud, and your results are returned to the worksheet, including plots and visualizations.”
The cloud running option makes this DOA for anyone but annoying silicon-valley corporate bros who have no idea the implications of uploading all of their sensitive financial data to Microsoft servers for processing.
Why would anyone still use this shit software if he is fluent in Python, Pandas and Seaborne?
workplaces use excel
Literally the first thing I thought. Why, if I know python, would I ever use Excel? I suppose it might allow people who don’t know python to copy macros of others without understanding them.
Well now you can do it without exporting data to a notebook. Just lowers barrier to entry for middle managers etc. who want stuff done without having to step out of their comfort zone
