Python for Excel - The Book: Learn more
Python for Excel
and other innovative solutions for modern Excel developers
Current xlwings release: v0.21.4 (23 November 2020) .
You're in good company
INTERACTION / AUTOMATION
Leverage Python's scientific stack for interactive data analysis using Jupyter Notebooks, NumPy, Pandas, scikit-learn etc. Or use xlwings to automate Excel reports with Python (Windows & Mac).
MACROS AND EXCEL TOOLS
Write Excel tools with Python instead of VBA and call your code directly from within Excel, e.g. via a button on the sheet. This also works great for prototyping web apps (Windows & Mac).
USER DEFINED FUNCTIONS
Write (array) UDFs in a breeze by taking advantage of all the functionality already available in libraries like NumPy and Pandas. Since v0.10, dynamic array formulas are supported (Windows only).
REST API
Expose your workbooks via REST API and access them from other computers in your corporate intranet or over the web. See the REST API docs.
What Our Users Say
xlwings has been invaluable in bringing the power of Python to the Excel front-end many business users are familiar with.
Daniel Guetta, Senior Lecturer, Columbia Business School
The xlwings video course is excellent…it covers everything you need to know, from getting started all the way through to advanced topics.
Scott Pritchard, Credit Analyst, Finland