Detecting strikethrough text from Excel?

[mlauber71]

@Snowy I once built a workflow that would identify excel cells by color. Maybe that could serve as an inspiration. If you have a sample file handy I would like to try that. Otherwise I can come up with a sample of my own.

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…