Filter Excel table by colour

[Rokank]

Hi, I have a table in excel which I need to filter the colour by “no fill” in Knime.

Thanks in advance

[Rokank]

Example.xlsx (8.5 KB)
I attached an example.
Below is what I am expecting

[mlauber71]

Well, it is possible to do that with the help of Python’s Openpyxl (like with so many Excel manipulation tasks in and around KNIME).

Basically what happens is this:

• Import the Excel file into python
• activate the “Sheet1”
• find the edges, in this case, the no of rows
• iterate thru all of the cells with data in column A
• extract the style information (that was some piece of work)
• Store them in the corresponding column C
• check if the style information contains the specific colour we want to see (you could drop that once you are comfortable with the solution)
• if yes write TRUE if not FASLE into column B
• save the Excel file under a new name (so you might keep your original file)
• check the results

You could adapt that to more style information

Filter an Excel file using style elements like color of the cell extracted...

Please note within the workflow is a subdirectory that contains a Jupyter notebook I used to first explore the functions. And it is possible that this is not the most elegant way - I wanted to demonstrate that it can be done.

And yes. Excel offers a native solution to filtering such data. So another possibility might be to filter your data before loading it into KNIME.