TOP

Create Jupyter notebook

Export > Create Jupyter notebook

This tool allows you to quickly create a Jupyter notebook file (*.ipynb) with Python code that retrieves data from the selected range. This eliminates the need to manually copy data and write initial code for their processing or visualization in Python within the Jupyter environment.

The tool creates a *.ipynb file containing Python code for creating and initializing a Pandas DataFrame object, which refers to values only from selected cells (ignoring formulas) and is ready for use in your Jupyter notebook.


Screenshot

Export > Create Jupyter notebook

After applying:

Export > Create Jupyter notebook

Running this tool

Click YLC Utilities > Export > Create Jupyter notebook :

YLC Utilities > Export › Create Jupyter notebook
YLC Utilities > Export › Create Jupyter notebook

How much time will this save?

By using this tool, you are guaranteed to save time and effort. However, the actual time savings depend on how often you use Excel (Calc), the amount of data you work with, and how often you use this tool.

Download extension

You can use the utility Create Jupyter notebook by installing the extension YLC Utilities.

After this, this function will be available in all files that are opened in Excel (LibreOffice Calc).


Additional keywords for this tool:
Export data, save to ipynb, range in notebook, data extraction, Python, Jupyter

The YLC Utilities menu in LO Calc

The YLC Utilities menu in LO Calc

The YLC Utilities menu in Excel

The YLC Utilities menu in Excel