Filtrar filas con colores de un archivo de Excell

[Athus]

Saludos a todos.

Tengo un archivo de excell, donde la propiedad para filtrarlo es el color de las celdas (azul), por lo que quisiera saber si existe una forma de mantener sea propiedad (el color de la celda o fila) como un metadato o algo similar para poder hacer dicho filtro en knime o si existe algún nodo que lo realice.

Muchas gracias

[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…