Python Jupyter Notebooks in Excel

Embed Jupyter into Microsoft Excel and write Python instead of VBA!

It used to be an “either/or” choice between Excel and Python Jupyter Notebooks.

With the introduction of the PyXLL-Jupyter package now you can use both together, side by side.

In this post you will see how to set up Jupyter Notebooks running inside Excel. Share data between the two and even call Python functions written in your Jupyter notebook from your Excel workbook!

Source: pyxll

And here you can find another guide, to help with integration:


Also checkout Azure Data Studio.
It’s killer.
You would forget all other platforms.
Available on Windows and Linux.