For example, this Python code snippet uses the Pandas library to read data from an Excel file and display the first five rows. import pandas as pd # Read the Excel file into a pandas DataFrame df ...

With Python scripts, you can even create new Excel workbooks, add or delete worksheets, merge data from different files, and ...

This allows the Python code to be executed directly in a browser-based Excel add-in. PyScript is based on Pyodide, a project originally launched by Mozilla for Python applications in the browser.

The company is using the Anaconda Python distribution — running in Azure — to bring the most popular Python libraries to Excel, including the likes of Matplotlib and seaborn for data ...