Just wonder if it is possible to create -asynchronous excel udfs in ExcelPython.
I have seen such a feature in ExcelDNA.
for example, we can create an UDF to call web services or a web request.
instead of waiting the function call to finish, it will return some state like 'processing'.
once the value is returned, it will automatically refresh the cell value via certain callback.
thanks,
Ark
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
This is not supported out-of-the-box right now, however you may be able to achieve a similar result by saving Application.Caller and returning immediately from the UDF, then subsequently writing the result to the desired cell once it's ready.
Perhaps in future better support for this kind of functionality will be available.
Kind regards,
Eric
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi all,
Just wonder if it is possible to create -asynchronous excel udfs in ExcelPython.
I have seen such a feature in ExcelDNA.
for example, we can create an UDF to call web services or a web request.
instead of waiting the function call to finish, it will return some state like 'processing'.
once the value is returned, it will automatically refresh the cell value via certain callback.
thanks,
Ark
Hello Ark,
This is not supported out-of-the-box right now, however you may be able to achieve a similar result by saving
Application.Callerand returning immediately from the UDF, then subsequently writing the result to the desired cell once it's ready.Perhaps in future better support for this kind of functionality will be available.
Kind regards,
Eric