From PC World: If you’ve been feeling constrained by Microsoft Excel’s methods for manipulating data, you’re in luck—Python can now be used within your spreadsheets. The inclusion of the popular programming language went live earlier this week, with the feature available as a public preview.
According to Microsoft, this integration is completely native within Excel; you won’t need to run any setup for it to work. (However, you will need to be part of the Microsoft 365 Insider program to access preview features in Office apps.) You type Python code directly into cells using the new =PY() function, which then gets executed in the cloud. The results are displayed in the worksheet. In the examples shown by Microsoft, common actions like creating pivot tables and charts will be possible using Python. Microsoft’s partnership with Anaconda, a Python repository that contains popular libraries like Matplotlib, pandas, and scikit-learn, should also enable more advanced visualizations.
The only potential limitation is that everything runs in the cloud—you won’t have any access to local installations of Python, including any customizations you may have set up. This is in part for security purposes; Microsoft says Python in Excel is secured through use of isolated containers, with the code running in a hypervisor in Azure. Online workbooks are also opened in separate containers. (You can read more about Microsoft’s data security practices regarding Python in this support documentation.)
View: Full Article