[python-win32] returning #N/A to Excel via UDF

Sébastien de Menten sdementen at gmail.com
Wed Nov 17 03:12:24 EST 2021


I would like to return #N/A values to excel via an UDF written in python
(via xlwings)

Returning a `VARIANT(pythoncom.VT_ERROR, 2042)` from the UDF results in an
empty cell.
Is there within pywin32/pythoncom an equivalent of VBA `CVErr(xlErrNA)` ?

Sébastien
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.python.org/pipermail/python-win32/attachments/20211117/2a475638/attachment.html>


More information about the python-win32 mailing list