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
Used extensions & nodes
Created with KNIME Analytics Platform version 4.7.1
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
- Go to item
Legal
By using or downloading the workflow, you agree to our terms and conditions.