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."
Source: Microsoft
Microsoft treats Python in Excel like other embedded scripting languages, automatically blocking them if a document contains a Mark of The Web (MoTW).
Windows automatically adds MoTW flags to all documents and executables downloaded from untrusted sources, such as the internet, using a special 'Zone. Id' alternate data stream.
These MotW labels tell Windows, Microsoft Office, web browsers, and other apps that the file should be treated with suspicion and will cause the document to be opened in Protected View, preventing the execution of macros and embedded Python scripts.
"If you open a workbook that contains Python code from the internet, Excel Protected View won't run Python formulas in the workbook. If a workbook is opened with Microsoft Defender Application Guard, Python formulas don't run by default," explains Microsoft.
To test Python in Excel, join the Microsoft 365 Insider Program and enroll in the Beta channel. However, as previously said, this feature may take some time to roll out to everyone
Comments
IhateMicroSoft - 8 months ago
And in tomorrow's news, Excel files, embedded with malicious Python scripts, wreak havoc across the globe...
h_b_s - 8 months ago
I'd be less concerned about security issues than data privacy and code compatibility issues. Running the scripts external "in the cloud" can also inadvertently expose the data sets to others, which some regulatory regimes don't allow. The other problem is Python tends to be a bit of a moving target even between minor version updates. Complex scripts may not be compatible between minor updates. Pandas, NumPy, matplotlib etc are quite complex. Microsoft and corporations are bad about sitting on software versions till they die of desiccation. In 4 - 5 years "Excel Python" will probably be different than normal upstream Python everyone else uses leading to the same legacy support costs and issues any other out-of-step software system incurs like Visual Basic, COBOL, legacy Java, etc.
BrechtMo - 8 months ago
What happens to old Excel files with Python code embedded if Microsoft discontinues the Python cloud service? We already have to deal with ancient vbs macros in mission critical worksheets but at least those don't have any cloud dependencies.
Dominique1 - 8 months ago
Under the umbrella of security, imposing running the python code in a cloud jail, they impose a permanent connection to the Internet, plus their subscription sham. And the usefulness without the local files? :facepalm:
Had python been locally run, it would have been huge security risk. In the end, this is a pointless feature.