Skip to content

ExcelPython v2.0.1

Compare
Choose a tag to compare
@ericremoreynolds ericremoreynolds released this 18 Jul 15:51
· 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.