Skip to content

Welcome to XPyCode

XPyCode Logo

XPyCode is a powerful Excel-Python integration platform that brings the full power of Python directly into Microsoft Excel. Write, execute, and manage Python code seamlessly within your workbooks with a professional IDE, custom function publishing, comprehensive package management, and real-time debugging capabilities.

Key Features

  • Python in Excel

    Execute Python code with full access to Excel objects. Work with workbooks, worksheets, ranges, and more through an intuitive API.

  • Integrated IDE

    Monaco-based code editor with IntelliSense, syntax highlighting, code completion, and integrated debugging tools.

  • Package Manager

    Install and manage Python packages per workbook with automatic dependency resolution. Isolated environments for each workbook.

  • Custom Functions

    Publish Python functions as Excel User Defined Functions (UDFs). Use them like native Excel formulas with full type support.

  • Event Handling

    React to Excel events (worksheet changes, selections, calculations) with Python code. Build interactive spreadsheets.

  • On-Time Events

    Schedule Python functions to run at specific times, repeating intervals, or one-shot datetimes. Built-in timer management in the IDE.

  • Debugger

    Set breakpoints, step through code, inspect variables, and debug your Python scripts directly in the IDE.

  • Customizable Themes

    Dark and light themes for both the IDE and editor. Customize fonts, colors, and layout to match your preferences.

  • Object Management

    Save Python objects in the kernel and reuse them across code executions. Perfect for data analysis workflows.

🚀 Quick Start

Get started with XPyCode in just a few steps:

# Install XPyCode
pip install xpycode_master

# Launch the server
python -m xpycode_master

Then open Excel and access XPyCode through Add-ins → More AddIns → Shared Folder → XPyCode.

Get Started → View Tutorials →

What Can You Build?

XPyCode enables a wide range of Excel automation and data analysis scenarios:

  • Data Analysis: Use pandas, numpy, and scikit-learn with Excel data and return result in Excel
  • API Integration: Fetch data from REST APIs and display in worksheets
  • Custom Calculations: Build complex financial models with Python libraries
  • Report Automation: Generate formatted reports from Excel data
  • Machine Learning: Train models and make predictions within Excel
  • Database Connectivity: Query SQL databases and load results into Excel

Learning Path

  1. Installation Guide - Install XPyCode and set up your environment
  2. Quick Start - 5-minute walkthrough of core features
  3. First Function - Create and publish your first Excel function
  4. User Guide - Deep dive into IDE features and capabilities
  5. Tutorials - Step-by-step practical examples

Documentation Sections

  • Getting Started

    Installation, quick start guide, and creating your first function.

    Getting Started

  • User Guide

    Complete guide to IDE features, Excel integration, and package management.

    User Guide

  • Tutorials

    Practical step-by-step tutorials for common use cases.

    Tutorials

  • Reference

    Keyboard shortcuts, API reference, and troubleshooting guide.

    Reference

System Requirements

  • Operating System: Windows 10/11 (64-bit recommended)
  • Python: 3.9 or higher
  • Microsoft Excel: 2016 or later with Office.js Add-in support
  • Memory: 4GB RAM minimum, 8GB recommended
  • Disk Space: 500MB for installation plus space for packages

Platform Support

While XPyCode is primarily designed for Windows, other platforms are enabled but not extensively tested. Community feedback welcome!

Getting Help

License

XPyCode is licensed under the MIT License with Commons Clause. You are free to use, modify, and distribute the software for any purpose, but you may not sell it as a commercial product.

See the License page for full details.

Ready to supercharge Excel with Python?

Get Started Now