Icon

Excel - Tables within a Sheet determined by Colour - KNIME Forum (79209)

Excel File - determine blocks with separate Tables with the help of the cell colors of the table headers using Python / Openpyxl

URL: Excel Import Blocks https://forum.knime.com/t/move-head-rows-to-a-column/45094/2?u=mlauber71
URL: Filter an Excel file using style elements like color of the cell extracted with the help of Python openpyxl https://forum.knime.com/t/filter-excel-table-by-colour/20633/3?u=mlauber71
URL: KNIME Forum (79209) - Data Transformation of unstructured excel data https://forum.knime.com/t/data-transformation-of-unstructured-excel-data/79209/2?u=mlauber71
URL: KNIME Blog: How to Set Up Your Python Extensions https://www.knime.com/blog/how-to-setup-the-python-extension

if(column("Color").equals("Theme Color")) {

column("Drawing Number")

} else {

toNull( "")

}

Excel File - determine blocks with separate Tables with the help of the cell colors of the table headers using Python / Openpyxl

https://forum.knime.com/t/data-transformation-of-unstructured-excel-data/79209/2?u=mlauber71

Path to String (Variable)
Extract the Cell colorsfrom the first columnto identify the blocksincluding a detailed XML definition
Python Script
URL to File Path (Variable)
Column Resorter
Drawing_Blockfill with previous valesto create block identifications
Missing Value
Extract the Cell colorsfrom the first columnto identify the blocks
Python Script
result.xlsx
Excel Writer
Add a new column with row numbers starting from 1rowIndex() + 1Long Number format
Column Expressions (legacy)
Path
Table Row to Variable
RowIndex
RowID
Read Excel Sheet Names
Joiner
Tracker
List Files/Folders
Drawing_Block
Column Expressions (legacy)
Tracker.xlsxFill Flow Variables with Excel File Path andSheet Namedo not skip any empty lines
Excel Reader
delete emptyrows
Row Filter (deprecated)
Sheet1
Row Filter
Check How manyColors there are
GroupBy
Sheet
Table Row to Variable

Nodes

Extensions

  • No modules found

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: m_lauber
Created at: 2024-05-16
On NodePit since: 2024-05-17
Last update: 2026-07-22
Created with KNIME version: v5.12.0
Tags: ExcelOpenPyxlBlockIdentifyTable

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!