Microsoft announces integration of Python programming capabilities in Excel

For many high-end Excel users, they also expect to be able to analyze data more comprehensively. Microsoft announced that Excel is adding Python functionality, which will allow users to add Python code directly to spreadsheets.

This feature will enable data analysts, engineers, marketers to use Python code in Excel for complex statistical analysis, advanced visualizations, predictive analytics and even machines study. Users will be able to enter Python code directly into cells using the new =PY Function, as Python will be integrated directly into Excel cells without the need to install additional software.

#Microsoft explains that the new feature uses the Anaconda Python distribution targeted at data scientists and engineers and is also beginner-friendly. Anaconda includes many prepackaged libraries and packages such as pandas, Matplotlib, scikit-learn, NumPy, and SciPy.

To improve security, Microsoft says Python in Excel runs on the Microsoft Cloud with the enterprise-grade security of Microsoft 365. This means code is executed on the Microsoft Cloud rather than on-premises, running in isolated containers using Azure Container Instances and separated from other processes to reduce the risk of unauthorized access. Data in the user's worksheet is controlled through specific functions xl() and =PY() to ensure data security and only authorized operations are performed.

The public preview of Python integration on Microsoft Excel will be available for the Microsoft 365 Insiders Beta channel using Excel for Windows.

The above is the detailed content of Microsoft announces integration of Python programming capabilities in Excel. For more information, please follow other related articles on the PHP Chinese website!