Python calculations run in the Microsoft Cloud, with the results returned into an Excel worksheet.
Weird choice, so it has to be due to wanting to Paywall it (they mention that at the bottom of the article). Otherwise I’d rather have the option to install python locally and speed up my queries when working on large data sets
But who wants to deal with excel then. Running python in the cloud and have it put data into an excel file is something I can already do, and as a bonus I can do it locally too.
Weird choice, so it has to be due to wanting to Paywall it (they mention that at the bottom of the article). Otherwise I’d rather have the option to install python locally and speed up my queries when working on large data sets
They probably also don’t want to deal with all the security vulnerabilities that came with VBA macros again.
But who wants to deal with excel then. Running python in the cloud and have it put data into an excel file is something I can already do, and as a bonus I can do it locally too.