How to use excel cell value in the target property of the Click function

Help
1

Hello Team,

I am trying to read a value from Excel sheet and pass it on to browser Click function to simulate the click.

The “Read Range” is created with output data table variable as xlinname (DataTable variable type).Using for each row, simulating a click using click function I am using the below syntax, but can some one help me on how I can pass the individual cell value for every for each row activity.

image
image1168×85 5.05 KB

from the above code , i see this might not be correct one, as I am passing the whole table. Instead I need to pass the A2 cell value for the first time, A3 cell value and then A4 cell value…and so on.

Please help how I can access individual cells in the above selector syntax.

Thanks,
VIvek

2

Inside for each row use Convert.ToString(row(“column name/column number”)) as input to your selector of click activity instead of xlinname.tostring().

3

Hello,

Thanks for your response, I replaced the xlinname as below. But now I am getting below error message.

image
image928×350 10.2 KB

image .

But in the excel sheet the header is same as the one given in the syntax (Instance Name).

image

Can you please help on what I am missing.

Thanks,
Vivek

4

Do you need square brackets around the column name, like “[Instance Name]”

5

Hello,

The selected range for the excel didnt include the header column and hence is the error. Now updated the read excel range and used the below selector, it worked.

image

Thanks,
Vivek

1 Like