How to read excel using uipath?

Help
1

I have an input file in excel format:

image

Each file creates one order. I will have multiple files for multiple orders.

How do i make my bot read these header and line info ??

My issue is : column b5 is customer value in this file, next file may have it in b4 or b2. So how do handle it ??

2

Try reading the range and then check each cell for a value.

3

Use Lookup range Activity to find the row number where the CUSTOMER value is coming.
Then use the Read Cell activity with the row number found in the previous step to read the customer name.

4

Reading range, but this range may vary from file to file.

How do i handle it?