Jupyter Notebooks in Excel¶

Jupyter Notebook¶

This video shows how the pyxll-jupyter package works and how to install it so you can use Jupyter notebooks with Excel and PyXLL.

This video covers the following topics:

1. Opening a Jupyter notebook in Excel

2. Fetching Excel data into the notebook as a pandas DataFrame

3. Pasting Python data into Excel from a notebook

4. Plotting in the notebook and in Excel

5. Writing Excel user defined functions in a Python notebook

6. Installing PyXLL and the pyxll-jupyter package

Documentation for the pyxll-jupyter package and the magic commands used in the video can be found at https://pypi.org/project/pyxll-jupyter.

The source code for the pyxll-jupyter package is available on GitHub here https://github.com/pyxll/pyxll-jupyter.

JupyterLab¶

JupyterLab is the latest Jupyter environment and a popular alternative to the more basic Jupyter Notebook.

The pyxll-jupyter package also enables JupyterLab to be embedded in Excel in the same way as the Jupyter notebooks above.

This video covers the following topics:

1. Using JupyterLab in Excel

2. Installing and/or updating the pyxll-jupyter package.

3. Installing and running JupyterLab.

4. Configuring pyxll-jupyter to use JupyterLab.

Version 4.0 of JupyterLab or later is required to use JupyterLab with pyxll-jupyter.