default values in udf

[Ark Wu]

all,

I just started trying ExcelPython, I found the concept is fantastic and it works quite well for me so far.
Just wonder if ExcelPython currently supports the default value in function (Optional Parameters in vba).
the example would be as follow:
in py file
@xlfunc
def test(a="Hello"):
return a
in excel
the formula could be either =test() or =test("aaa").

thanks for advance.

Regards
Ark

[Eric Reynolds]

Hello Ark,

This feature is not currently in ExcelPython but I don't believe it would be difficult to implement. Currently ExcelPython is being integrated into xlwings, so we will probably add this feature at a later stage.

Thanks for the idea, kind regards,

Eric