Python in Excel: The Future or Merely a Gimmick?

Several vendors are proposing alternative, with local Python execution with sandboxing and without local deployment of Python, leveraging WASM with Pyodide (which now supports Pandas, Duckdb, ...).

it is the case of XLWings lite https://lite.xlwings.org) and even Anaconda who partners with Microsoft for the distribution running in Azure, has developed such flavor (Anaconda Code https://www.anaconda.com/docs/tools/excel/code).

so to run native Python you end up depending on Azure. and to run Python locally you depdend on initially Web centric technologies in this case Typescript, Wasm, WebWorker...

I would rather use Jupyter Notebooks, a sort of "excel within python" rather than the converse. And it exists today. I have Carnets running on an ipad, "trusted", with no dependence on Microsoft services.

> Rather than executing the Python code on your local PC, Excel sends it to the cloud, where it is processed in a secure environment managed by Microsoft.

Microsoft is increasingly following the Sun "Sunray" model, IMO. "Azure is the computer."

Python with open office calc is doing a great job for years.