Determine cell color (and other formatting) within an Excel sheet?

Hi,

Here is a use case I'm working with. A user sends me an Excel spreadsheet and says 'please use data on all the green rows to query the database for field XYZ and use it to augment the sheet.'

Is there a way to determine which rows/cells within the sheet are green (or bold or have borders or...) within an Excel sheet read into KNIME?

That would be a useful feature!

Mitch

Mitch,

It's quite clunky, but you can read xlsx files as wit the XML Reader and determine cell formats via XPath. Also works with pptx files etc. Awkward, but occasionally a nice end-user interface option.

Cheers
E