Linking Python docstrings to Excel Function Wizard
An interface for calling Python from Excel
Brought to you by:
ericreynolds
Menu
▾
▴
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.