Pluckerpluck/xlwings

xlwings is a BSD-licensed Python library that makes it easy to call Python from Excel and vice versa. It works with Microsoft Excel on Windows and Mac. Sign up for the newsletter or follow us on twitter via

xlwings - Make Excel fly with Python!

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 that is close to VBA.
• Macros: Replace your messy 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.

Links

• Homepage: https://www.xlwings.org
• Quickstart: https://docs.xlwings.org/en/stable/quickstart.html
• Documentation: https://docs.xlwings.org
• Video Course: https://training.zoomeranalytics.com/p/xlwings
• Source Code: https://github.com/zoomeranalytics/xlwings

xltrail

The Excel add-in is version controlled with xltrail. You can see the diffs on https://demo.xltrail.com.