call python function from excel

You could try xlOil (disclaimer: I wrote it). The docs are here, but to write a simple three input function, you would install xlOil using:

pip install xloil
xloil install

Then write:

import xloil

@xloil.func
def myfunc(x, y, z):
    return x + y * z

Put this code either:

1. In a py file in the same directory as your spreadsheet, named SpreadsheetName.py
2. In a py file on your python module path, then edit %APPDATA%\xlOil\xlOil.ini to load it as described in the docs.

Start Excel, open your spreadsheet and the function will be available as myfunc.

You could also try xlSlim (disclaimer I wrote it). The docs are here.

Installation is as simple as downloading and running a Windows installer from here The process is described in the docs and there is a YouTube video https://youtu.be/Zl5QM8rGBC8 It is straightforward, just download and run the installer. The installer is digitally signed and virus scanned.

Then to create the same function as Steve's you would write your function in a Python module:

def myfunc(x,y,z):
    return x + y + z

(Note how no changes were made for the function work with xlSlim - this is a defining feature of xlSlim, no decorators or additional Python packages are required.)

Then in Excel use the RegisterPyModule() function to register the module (assuming you saved the module as mymod.py)

=RegisterPyModule("C:\Users\russe\Documents\mymod.py")

The function is now available for use within Excel as myfunc. Any type hints and doc strings are also processed.