knime to Sort Excel Sheets to extract data

Hi All,

I’m having “n” number of folders. I’ve used List files to filter my xlsx workbooks.

In Each workbook i have 25 to 30 sheets.

I want to loop thru each sheet in workbook and search a key word.

If key word exist i want only that sheet to be pulled out for further transformation.

Note: Data structure is irregular (a possibility)

any suggestions on how to move ahead is greatly appreciated

Thank you in advance

Next step would be to check whether the keyword is part of the data table. Is the keyword part of a document type like string or just a nominal value? Do you expect to find the keyword in a specific column?

Hi Marten_Pfannenschmidt,

The Key word is a string like “XYZ Calculation”

When i loop thru each sheet the possibility of string to occur is in 2 or 3 out of 25 sheets per work book

So i need to extract those 2 or 3 sheets only from each work book rest to be excluded.

Regards,
Harsha

This topic was automatically closed 182 days after the last reply. New replies are no longer allowed.