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: