use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file. Then use the index numbers to import the files back

use KNIME and Python OpenPyxl to read the index numbers of every sheet in an Excel file. Then use the index numbers to import the files back
("did someone say overengineered ...?")
there is a Jupyter notebook in the /data/kn_example_python_excel_sheet_index.ipynb folder to experiemnt with

-----------------
conda install -c conda-forge jupyterlab notebook
conda install -c conda-forge notebook

conda activate py3_knime
jupyter notebook

External resources

• (official) KNIME Python Integration Guide
• Meta Collection about KNIME and Python
• forum entry