XPyCode

XPyCode is a platform designed to integrate Python directly into Microsoft Excel, enabling users to write, execute, and manage Python code within Excel workbooks. It addresses the need for advanced automation and data manipulation by allowing Python scripts to interact with Excel objects, such as worksheets, ranges, and formatting, all from within the familiar Excel environment.

The tool features a full-featured integrated development environment (IDE) based on the Monaco code editor. This IDE provides IntelliSense with auto-completion, syntax highlighting, error detection, a project explorer with module management, variable inspector, watch panels, and customizable themes. Users can set breakpoints, step through code, and inspect variables using the real-time debugger. XPyCode also supports publishing custom Python functions as Excel formulas, allowing them to be used like native Excel functions. Additionally, the platform enables event handling with Python callback functions that can react to changes or selections in Excel worksheets.

XPyCode includes a package manager that allows users to install and manage Python packages on a per-workbook basis, with support for full dependency resolution and version control. js-based Excel add-in, a FastAPI message broker in the business layer, and a Python IDE built with PySide6 and Monaco Editor, providing a modular and flexible system. Each workbook operates in its own Python execution environment.

Installation is available via an all-in-one installer for Windows 10/11 (64-bit) and MacOS 14 or higher, with experimental support for Linux. Alternatively, users can install XPyCode using pip, either with automatic setup or by manually starting the server. The add-in is loaded into Excel through the Add-Ins interface, and the development environment is launched from within Excel itself. 9 or higher.