Announcing Python in Excel

That's actually a GOOD feature since python is specifically suited for A.I and any sort of analytics. It would be great too if EXCEL stopped using VBA completely too -- but that's a bit more difficult to do though as there's probably zillions of users wold wide still using VBA macros in excel.

However the cloud restriction is a bit restricting for individual users who would prefer a local facility.

I'm fiddling around with a function in standard EXCEL which could call a python program so this facility could work on recent versions of EXCEL -- the python code is easy enough -- I use it on Linux -- I need to get up to speed with python on Windows - as I'm missing the odd library or two !!! -- still something to do.

I'm starting from this snippet I found on the web


The possible "snag" I might run into is that I might need an OBDC type of data connector for the python stuff -- but if from python I'm getting data from an MySQL type DB the required OBDC connectors for Windows > Mariadb/MySQL are downloadable anyway (Free) from Mariadb or MySQL site for either of those DB systems.

Cheers
jimbo