xlwings - Make Excel Fly!

xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa:

  • Scripting: Automate/interact with Excel from Python using a syntax close to VBA.

  • Macros: Replace VBA macros with clean and powerful Python code.

  • UDFs: Write User Defined Functions (UDFs) in Python (Windows only).

  • REST API: Expose your Excel workbooks via REST API.

Numpy arrays and Pandas Series/DataFrames are fully supported. xlwings-powered workbooks are easy to distribute and work on Windows and Mac.

Getting Started

Start here if you are new to xlwings. Learn about the syntax, the RunPython call, the add-in and UDFs.

Advanced Features

More in-depths explanations about converters, debugging or how to write your own add-in.

xlwings PRO

xlwings PRO offers additional functionality including xlwings Reports, the template-based reporting system.

API Reference

This is a description of all the classes, methods, properties and functions that xlwings offers to work with the Excel object model.