xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa:
- Interact with Excel from Python using a syntax that is close to VBA yet Pythonic.
- Replace your VBA macros with Python code and still pass around your workbooks as easily as before.
xlwings fully supports NumPy arrays and Pandas DataFrames. It works with Microsoft Excel on Windows and Mac.
Note
xlwings is currently in an early stage. The API might change in backward incompatible ways.
.. toctree::
:maxdepth: 2
:hidden:
whatsnew
installation
quickstart
datastructures
vba
debugging
udfs
api