Filtrar filas con colores de un archivo de Excell

[mlauber71]

@Athus welcome to the KNIME forum. I have demonstrated the option to extract Excel cell colours with three help of openpyxl which is now integrated in the standard knime python extension.

Filter Excel table by colour

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 (yo…