Excel Header Query

Learn
1

Hii,

Excel attachedMasterSheet.xlsx (9.6 KB)

The Excel contains table with the headers as Name,gross…

The position of the table changes

How to read only that Table

Regards,
Supriya

1 Like
2

Hi @supu123,

you can use loopup range acivity and you will get the cell address . through that you can capture the specific form of table
Ex:
BlankProcess5 (2).zip (17.4 KB)

3

Hi @prakaz25

Column header position me change like if Net is the Last column now it can become 3rd column

Regards,
Supriya

Regards,
Supriya

4

Hi @supu123

you can skip that part and give total number of column …you can alter as per requirement. i just gave an idea.

5

Hi @prakaz25

In the given xaml file
The end range prints a blank value

what is it suppose to print
image

Thanks and Regards,
Supriya

6

Hi @supu123,

According to the excel sheet it suppose to be print exact range of “NET” value. lookup range acitivity used to find the value which is given and return the address of the value

Regards
Prakash M

7

BlankProcess5.zip (20.6 KB)

Hi @prakaz25

Not getting y it is printing blank

Regards,
Supriya

8

BlankProcess5 (2).zip (17.4 KB)

You missed the Data Value range… am considering that range-1 as end range.
If you dont’t want that just you put Start range only