As far as I know, the only thing that the new python integration helps with is that users don't have to install Python or have to know how to use pip to install packages like pandas, because Python doesn't run locally. It is neat how you can visualize data and show it inline with the Excel document though. My industry is very regulated, so we won't be able to use it since the data you pass to Python goes to Azure for processing
I think Microsoft recently introduced Python support in Excel, so maybe you can combine both.
It's tied up with their azure cloud service and I kinda combine both already with pandas.read_excel() and DataFrame.to_excel().
As far as I know, the only thing that the new python integration helps with is that users don't have to install Python or have to know how to use pip to install packages like pandas, because Python doesn't run locally. It is neat how you can visualize data and show it inline with the Excel document though. My industry is very regulated, so we won't be able to use it since the data you pass to Python goes to Azure for processing
They did