Hi everyone,
I just recently had access to Python in Excel and am exploring my options a bit.
I was able to create user-defined functions using the xlwings Add-in, however, it had some limitations.
Now that there is Python in Excel I was wondering if there was any way to do the same with it. However, I noticed right away that you are not able to reference external .py files as only the pre-imported libraries from Python are supported.
Do you know if it possible to create something like =function(a,b)
function_result = a+b
Maybe using VBA or OfficeScripts to import my .py function and then run it with =PY()?
Any other suggestions are welcome.
I just recently had access to Python in Excel and am exploring my options a bit.
I was able to create user-defined functions using the xlwings Add-in, however, it had some limitations.
Now that there is Python in Excel I was wondering if there was any way to do the same with it. However, I noticed right away that you are not able to reference external .py files as only the pre-imported libraries from Python are supported.
Do you know if it possible to create something like =function(a,b)
function_result = a+b
Maybe using VBA or OfficeScripts to import my .py function and then run it with =PY()?
Any other suggestions are welcome.
