Write, execute, and manage Python code directly within Microsoft Excel workbooks. Full-featured IDE, custom function publishing, package management, and real-time debugging.
Everything you need to supercharge Excel with Python
Run Python code with full access to Excel objects. Manipulate worksheets, ranges, and formatting directly from Python.
Monaco-based code editor with IntelliSense, syntax highlighting, and full debugging capabilities.
Install and manage Python packages per workbook with full dependency resolution and version control.
Publish Python functions as Excel formulas. Use them like any native Excel function.
React to Excel events like worksheet changes and selections with Python callback functions.
Set breakpoints, step through code, and inspect variables with a full-featured debugging experience.
The XPyCode IDE brings professional development tools directly to your Excel workflow.
Get up and running in minutes
Install the package using pip and start the master server.
pip install xpycode_master
Launch the XPyCode Master server which handles communication between Excel and Python.
python -m xpycode_master
Load the XPyCode add-in and launch the development environment.
<> Editor
Create modules and start writing Python code that interacts with Excel.
def updateExcelFromPython():
import xpycode
ws = xpycode.worksheets. getActiveWorksheet()
rA1 = ws.getRange("A1")
rA1.values = "Hello"
rA1.format.fill.color = "yellow"A modular design for flexibility and performance
Office.js-based interface
FastAPI message broker
PySide6 + Monaco Editor
Per-workbook execution environment
System requirements and quick setup
Windows 10/11 (64-bit)
Linux/macOS experimental3.10 or higher
2016 or later
With Office.js Add-in supportpip install xpycode_master
python -m xpycode_master
The Excel Add-in will be automatically registered.
Start using Python in Excel today with XPyCode