PyXLL using Jupyter and PySimpleGUI Interface (with video) Dec 2022

Check out the video below
PyXLL Jupyter Interface
I built a custom interface from Excel cells to my PyXLL hosted Jupyter notebook.

But this time — in December 2022 — I demonstrate PySimpleGUI, a high-quality graphical interface.


  • Sliders are easily customized
    • integer, decimal (with decimal places)
    • style, color, width, tick spacing, tick labeling
  • Custom graphic images are easily built. In this example,
    • I built a second dialog with a diagram of the user input
    • Labeled the image with the user input parameters
    • Saved the image as a PNG file for printing/copying


PySimpleGUI is my new go-to dialog approach.

There are several great plotting apps, Plotly for one; however, the plotting routines are not generic enough to build an image on an arbitrary coordinate system.

PySimpleGUI allows any arbitrary (linear) coordinate system with user defined positive directions: up, down, left, right.

Then, with a few primitives: rectangle, ellipse, line, text, et cetera, we can draw just about any diagram. This is ideal for engineering apps.

Professional results that are much easier and more flexible than those using PyQT or PySide.

Check out the video below

What is PyXLL-Jupyter?

Integration for Jupyter notebooks and Microsoft Excel.

PyXLL to Jupyter Interface (with video) Dec 2020

First video is short with no PyXLL; pure PySimpleGUI running inside Jupyter.

Second video is a bit longer. Starting in Excel using PyXLL, then invoking the Jupyter custom task pane (CTP), then illustrating PySimpleGUI running inside Jupyter.

Leave a Reply

Your email address will not be published. Required fields are marked *