Microsoft recently unveiled the Python Editor, an add-in for Excel that serves as a code editor specifically designed for Python programming language. This new feature, known as Python Editor, is a powerful code editor that runs in the sidebar of Excel. It provides a spacious area for writing code, allowing for longer code snippets to be displayed. The editor itself utilizes the same engine as VS Code, bringing with it a range of features such as IntelliSense, formatting, code completion, and syntax highlighting.
It is worth noting that the Python Editor is currently labeled as an experimental feature through the Excel Labs system. This means users will need to enable the Excel Labs add-in before gaining access to the Python Editor feature in the future.
TLDR: Microsoft has introduced the Python Editor, an add-in for Excel that offers a comprehensive code editing experience specifically tailored for Python programming. Utilizing the same engine as VS Code, the Python Editor provides various features, including IntelliSense, code completion, and syntax highlighting. However, it is currently an experimental feature accessible through the Excel Labs system, requiring users to enable the corresponding add-in.