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

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.

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

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

Hello,

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

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

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

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.

Thanks,
Vivek

1 Like