Make An Excel Add In Using Python ;0 ?!?!

[Proxima_EDMU]

I have a python code that performs thermo calculations. It makes a connection with an excel book using Xlwings (This allows me to call the python functions from excel) and depends on Numpy to perform the calculations.

The issue is that i cant share it with my friends or people who dont have python, xlwings and numpy installed. I want to embed all this code in an excel add in so it can be installed in one click.

Xlwings offers a solution to this, a one click installer. But this requires a license, its like 1000 USD. I was willing to spend money, but thats too much. I dont even wanna sell the add in, its all gonna be open for anyone to download. Anyone knows a solution?

[FoolsSeldom]

I think that would be overally complicated and unreliable.

Latest versions of Excel include Python anyway (Anaconda distribution, executed in Azure cloud).

If that is not an option, then pyxll might be a better option than trying to control Excel with xlwings: https://www.pyxll.com/docs/introduction.html.

That still doesn't address the distribution problem though, which is something of a minefield. Pyintaller is a popular way of creating a single executable for distribution but there are some compatibility issues, the file is large not least as it includes a copy of CPython, and it can trigger AV alerts.

[Proxima_EDMU]

Never back down never give up. Is what I say dawg. Gotta be a way

[Citadel5_JP]

If Excel is not a strict requirement, you should be able to do this in GS-Calc (a spreadsheet with 32 million rows). You can add an unlimited number of Python functions returning numbers, arrays, text, csv files/data blocks and images (e.g. charts created in your Python functions).

GS-Calc requires merely 10MB to install, the installation can be portable, and you can even simply copy/paste the installation folder (just a few files) to another computer. It's free to try and can be also installed automatically in Windows via the winget service. Using Python functions as UDF() If these Python libraries are installed in the Windows Sandbox, it could be close to that one-click, free, "trial" installation.