Named range and tables in Excel

@zioludo there is no dedicated node but you can use the bundled Python version of KNIME and OpenPyxl to handle tables and named ranges with KNIME. Here are examples:


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 define and name a Data area in Excel (using the bundled Python version)

3 Likes