xlwings - Make Excel Fly!#

xlwings (Open Source) 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).

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

Work with Google Sheets & Excel on the web, use xlwings Reports (template-based reporting), embed your Python code for easy deployment and more. Free for noncommercial use only.

API Reference

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