Python Editor in Excel now rolling out to Windows users



 Excel Blog:

We are excited to announce that the Python Editor is now rolling out to Windows users.

A new way to edit your Python formulas​

Today we are excited to announce that the Python Editor is rolling out and will be generally available for Current Channel Windows users starting with 16.0.18129.20116. Last September we introduced the Python Editor as an experiment in Excel Labs. We then announced we were promoting the experiment to Insiders: Beta and now, we are excited to announce that the Python Editor is generally available, filling a gap between the availability of Python in Excel and the task pane editor.

bS00MjkyMTg0LWRpclR5dw

Chart preview in Python Editor.

With the Python Editor, users can enhance their Python in Excel experience by utilizing a larger editing space for writing and editing Python formulas. It features productivity tools like Intellisense, syntax highlighting, and function help, like those found in Python notebook environments. The editor allows users to see the flow of code execution with results, edit longer chunks of code, and gain flexibility with coding workflows. The Python Editor is designed to improve usability and control when working with Python in Excel.

If you’re interested in learning more about the Python Editor in general, be sure to check out our original blog: Graduating the Python Editor

The rest of this post will cover the improvements we have made during our journey from Beta to Production.

Editor upgrades​

We have been hard at work making improvements to Python Editor and are happy to announce some new changes we have made to the experience and how it integrates with Python in Excel.

Replacing the Diagnostics View​

We are now replacing the old diagnostics view with the Editor. We think this gives you all the information needed, in context, to debug your code. This also means that the editor pane will make use of the setting to automatically launch the pane upon an error or print statement.

To turn off this auto-open you can check out the setting within the editor pane.

Note: This experience is rolling out in waves and will be available to more users over time.
bS00MjkyMTg0LW5wN2F6Vw

Launch the pane automatically on errors or print statements.

Workbook Controls​

Prior to the latest update, the Python Editor was limited to editing only the active sheet in the workbook. We wanted to give users a one-stop shop to view all their Python code in the workbook. With this new update, you can do just that.

Multiple Sheets

Each sheet now has its own dedicated section with a header in the Python Editor. These can be expanded and collapsed if you aren’t interested in a current set of cells in the moment.

bS00MjkyMTg0LUtiZGtPYg

Manage the editor with new sheet groupings.

New Filter Controls

With the addition of potentially many more Python Formulas in the view, we have also added more granular control of what you’re editing.

bS00MjkyMTg0LTdmNldKQg

Granular filter controls for the editor.

Support for Excel References​

One of the great things about Python in Excel is how seamlessly you can make use of data contained in the grid. We have added support for creating Excel references within the ‘xl’ function. After typing, “xl(' ')” you can select your data from the grid, just like you would with any other formula. You can also edit your reference if you select within the parameter and make a new selection.

bS00MjkyMTg0LUo1cERDeQ

Automatically create excel references.

New Entry points​

We believe that the Python Editor should be accessible when you need it. As such, we have added several new entry points to make use of the Editor.

Keyboard ShortcutCTRL+ALT+SHIFT+F2Launch the editor without needing to click the mouse
Error Menu
bS00MjkyMTg0LU1KcXRqYw

New options in the error menu.
Quickly edit your code and reference the relevant error
Python Cell Context Menu
bS00MjkyMTg0LW1uSkxtbg

New entry point in the right-click context menu.
Quickly launch the editor from any python cell

Bug Fixes​

Finally, we have been fixing many bugs and issues found during rollout. Thank you to everyone who reported bugs and provided feedback along the way!

Thank You for Your Feedback During Preview​

We appreciate everyone who tested the feature, provided early feedback, identified issues, and created content during the initial rollout within the Insiders audience. Your assistance and feedback were crucial in getting us to our current version. We are constantly inspired by what the community has built using Python in Excel already and are excited for an improved experience to be more readily available.

We Want Your Feedback!​

Excel and Python users can give feedback directly within the application (go to Help > Feedback), suggest improvements on our Feedback portal, or engage with our team on GitHub.

Availability​

Python Editor:​

The Python Editor is available on Windows Current Channel starting with build 16.0.18129.20116.

Python in Excel:​

Python in Excel is now generally available for Windows users of Microsoft 365 Business and Enterprise. With qualifying Microsoft 365 subscriptions, you can calculate Python formulas with standard compute and automatic recalculation mode. For faster calculations with premium compute and access to manual or partial recalculation modes, you must purchase the Python in Excel add-on license or request the license from your administrator.

To learn more about specific details on versions and channels, please check out Python in Excel availability.

Other resources:​

Python Editor Help
Introduction to Python in Excel
Getting started with Python in Excel
Learn more about Anaconda
Learn Python in Excel with LinkedIn Learning


 Source:

 
To celebrate this, I will program Snake in Excel using the "SNEK"-language in the new editor. :party: 🐍
 

My Computers

System One System Two

  • OS
    Windows 11 Pro 23H2 build 10.0.22631.4825 (Release Channel) / Linux Mint 22.1 Cinnamon
    Computer type
    Laptop
    Manufacturer/Model
    Lenovo A485
    CPU
    Ryzen 7 2700U Pro
    Motherboard
    Lenovo (WiFi/BT module upgraded to Intel Wireless-AC-9260)
    Memory
    32GB
    Graphics Card(s)
    iGPU Vega 10
    Sound Card
    Realtek
    Monitor(s) Displays
    14" FHD (built-in) + 14" Lenovo Thinkvision M14t (touch+pen) + 32" Asus PB328
    Screen Resolution
    FHD + FHD + 1440p
    Hard Drives
    Intel 660p m.2 nVME PCIe3.0 x2 512GB
    PSU
    65W
    Keyboard
    Thinkpad / Logitech MX Keys
    Mouse
    Logitech MX Master 2S
    Internet Speed
    600/300Mbit
    Browser
    Edge (Chromium)
    Antivirus
    Windows Defender
    Other Info
    SecureBoot: Enabled
    TPM2.0: Enabled
    AMD-V: Enabled
  • Operating System
    Windows 11 Pro 23H2 build 10.0.22631.4825(Release Preview Channel)
    Computer type
    PC/Desktop
    Manufacturer/Model
    Custom
    CPU
    i7-7700k @4.8GHz
    Motherboard
    Asus PRIME Z270-A
    Memory
    32GB 2x16GB 2133MHz CL15
    Graphics card(s)
    EVGA GTX1080Ti FTW 11GB
    Sound Card
    Integrated
    Monitor(s) Displays
    32" 10-bit Asus PB328Q
    Screen Resolution
    WQHD 2560x1440
    Hard Drives
    512GB ADATA SX8000NP NVMe PCIe Gen 3 x4
    PSU
    850W
    Case
    Fractal Design Define 7
    Cooling
    Noctua NH-D15 chromax.black
    Mouse
    Logitech MX Master 2S
    Keyboard
    Logitech MX Keys
    Internet Speed
    600/300Mbit
    Browser
    Edge (Cromium)
    Antivirus
    Windows Defender
    Other Info
    AC WiFi Card
Back
Top Bottom