One of the nice features of Pyxll is that the text in the Python docstrings is automatically linked to the Excel Function Wizard. Also you can allocate the function to a help topic, through the function @XLfunc decorator. This makes documenting UDF usage easier with Python than it is with VBA!
Is there any way to do this with ExcelPython?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Not that I know of, besides ExcelPython does not dynamically define UDFs as
it is not an Excel add-in but a COM typelib.
The idea of ExcelPython is to provide a limited set of primitive functions
for manipulating Python objects which can then be built upon to do what you
need, rather than ready made solutions for everything.
When I have a moment I'll see if I can come up with a few recipes for doing
the kind of thing you want to do.
One of the nice features of Pyxll is that the text in the Python docstrings is automatically linked to the Excel Function Wizard. Also you can allocate the function to a help topic, through the function @XLfunc decorator. This makes documenting UDF usage easier with Python than it is with VBA!
Is there any way to do this with ExcelPython?
Not that I know of, besides ExcelPython does not dynamically define UDFs as
it is not an Excel add-in but a COM typelib.
The idea of ExcelPython is to provide a limited set of primitive functions
for manipulating Python objects which can then be built upon to do what you
need, rather than ready made solutions for everything.
When I have a moment I'll see if I can come up with a few recipes for doing
the kind of thing you want to do.
Thanks Eric. If you do find the time to have a look at that I'd really appreciate it. Also I'll post here if I find a solution myself.