Read multiple excel files and extract information of certain cells

Hello all,

I need to build a flow were I can read multiple excel files and extract information from certain cells and write it on specific columns

I attached the next picture:

So each file is going to contain infor in differents cells and sheets, I need to extract that info and write it in another table.

And run this flow for each file.

Thanks for the help!

@lgarduno I think it should be possible to do that. We had a somewhat similar discussion here:

It all depends on how ‘regular’ your structure is and how many variations there are. You could modify the above approach or import the whole dataset into a KNIME table and deal with the data later.

The best thing would be you could create a sample file that best represents you whole set of challenges (without giving away any confidential data).


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