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).

3 Likes