How effective do you think the new Python function feature in Excel?

[gifariz]

I saw the new Python function is added to Excel since August 2024. How effective do you think this new feature is?
I always prefer macro-free excel. I was happy at first when LAMBDA feature was released, such revolutionary. I used it for many custom functions. Then I realize it slows down my heavy computation excel, so I now use it only when really necessary. The one-continuous-line syntax limitation is also inconvenient to read/edit.

The Python feature seems revolutionary: creating custom functions, multi-line syntax, calling external libraries, computations done by Microsoft Clouds. Just wow.
What else we can do? Any drawback? Maybe this feature needs another sub-forum? What do you guys think?

 

[datatronics505]

It would be interesting if Python for Excel can replace VBA scripts. Can it, though?

 

[gifariz]

It would be interesting if Python for Excel can replace VBA scripts. Can it, though?

Not yet apparently. Would be wonderful to use the python libraries there as well.

I found one drawback: it is slow.
Slower than lambda. Probably due to the cloud computing.
So may need care to use it, mostly useful for functions not available in excel, but not for heavy calculation or numerous callings.