Python Jupyter Notebooks in Microsoft Excel
Use Python Juputer Notebooks inside Microsoft Excel using PyXLL for data analysis and using Python as a VBA replacement.
PyXLL: https://www.pyxll.com
PyXLL-Jupyter: https://pypi.org/project/pyxll-jupyter/
Write Python code to explore, process and analyse data in Excel, and use Python instead of VBA for scripting Excel or writing UDFs (worksheet functions).
1. Install PyXLL using "pip install pyxll" and then "pyxll install"
2. Install pyxll-jupyter using "pip install pyxll-jupyter"