KNIME and Python's openpyxl to extract named tables (ranges) from Excel file (using the bundled KNIME Python version)

KNIME and Python's openpyxl to extract named tables (ranges) from Excel file (using the bundled KNIME Python version)
https://forum.knime.com/t/read-from-excel-table/38190/8?u=mlauber71

The Excel File "Tables.xlsx" contains 4 named Table ranges which will be imported into KNIME. First in one step. The second Python node would give back the cell ranges and use that information to extract the tables

External resources

• Manipulate Excel files in KNIME with Python openPyXL
• openpyxl - A Python library to read/write Excel 2010 xlsx/xlsm files
• (stackoverflow) how to extract different tables in excel sheet using python
• forum entry
• KNIME and Python's openpyxl to define and name a Data area in Excel
• KNIME and Python - Combine the best of visual programming with scripting
• openpyxl - A Python library to read/write Excel 2010 xlsx/xlsm files
• HUB: KNIME and Python's openpyxl to extract named tables (ranges) from Excel file (using the bundled KNIME Python version)
• BLOG: How to Set Up Your Python Extensions