Use Python in Excel like a Jupyter notebook

xlSlim v3.0.0 introduces a new interactive mode to xlSlim. Interactive mode lets Excel mimic the behaviour of Jupyter notebooks. Python code is stored and run within Excel cells. Output is returned in the cell below.

Double-clicking on any cell opens a new Python code editor.

Python code editor

Classes and functions are automatically created as Excel functions.

Interactive functions created as Excel functions

Excel objects can be directly accessed and manipulated.

Access and manipulate Excel objects

And much more!

Over the next weeks I will add YouTube videos and improve the documentation around interactive mode.

Please let me know what you think in the comments.

Read More

Leave a Comment