ExcelPython v2.0.1
·
135 commits
to master
since this release
ExcelPython becomes an Excel add-in!
- To use this release unzip it somewhere and open up
xlpython.xlam
- The smiley face button now does automatically the setup steps described in the docs (folder is now called
xlpython
). - The other button creates VBA wrapper functions for the functions contained in the Python script with the same name as your workbook. Here's an example
# Book1.py
from xlpython import xlfunc
@xlfunc
def DoubleSum(x, y):
"""Returns twice the sum of the two arguments"""
return 2 * (x + y)
Click the 'Import Python UDFs' button and you should then be able to use the function in cell formulas.