[Python] I got Excel 2024 & xlwings (open source) installed and working fine. Want to use UDFs...

I got Excel 2024 with xlwings (open source). My project works fine whenever I update data and then 'Run main' command from 'xlwings' ribbon.

Now I am trying to add few more functionalities for which I will have to write either VBA functions or I can use Pythong UDFs through xlwings. I am not willing to convert my .xlsx file to .xlsm just for this additional functionalities. Is there any way I can use Python UDFs in .xlsx file itself?

I tried xlwings lite in a seperate machine, custom Python UDFs works fine there on .xlsx file. Can xlwings (open source) also do the same? If yes, can someone please guide me. I tried doing it, but not working so far.

Thank you,

Continue reading...