Write Excel user-defined functions in Python!
from xlpython import *
@xlfunc
@xlarg("x", "nparray", 2)
@xlarg("y", "nparray", 2)
def matrixmult(x, y):
return x.dot(y)
ExcelPython is a lightweight, easily distributable library for interfacing Excel and Python. It enables easy access to Python scripts from Excel VBA, allowing you to substitute VBA with Python for complex automation tasks which would be facilitated by Python's extensive standard library while sparing you the complexities of Python COM programming.
- Download the latest release
- Check out the tutorials to help you get going
The only prerequisites are Excel and Python with PyWin32 installed.
Check out the docs folder for tutorials to help you get started and links to other resources. Failing that, try the issues section or the discussion forum on SourceForge.
If you still don't find your answer, need more help, find a bug, think of a useful new feature, or just want to give some feedback by letting us know what you're doing with ExcelPython, please go ahead and create an issue ticket!