Get Value from For loop using excel and passing value to Xpath

Hi Expert,

I am trying to read data from excel and pass to website. I am reading data from excel using Get Range. I loop through row and another loop to get single value. I need to pass those value to website in xpath. How to get second value in loop through index?

Please look into it.

Thanks,

Khalid

image1366×768 90.2 KB

ReadDataFromExcel.zip (1.5 KB)

Hi Khalid,

You can specify the Index in the second loop.

image1111×278 21.8 KB

ReadDataFromExcel.zip (1.3 KB)

Thanks @ashapkina

Hi,

I need to update last column of each row in excel from variable value. I am using forloop.
I already tick “save file after last action”. Below is my screen for the same.

image1366×768 109 KB

It is not setting value to cell to last cell.

Please look into it.

Thanks,

Khalid

It looks like you insert it in the same cell (current cell).
You should add an action to move the focus to some other cell after inserting the value.

image770×407 16.4 KB

Thanks for quick response. I tried, instead it is setting the value to start of column rather then last column.

Attaching screen and recording for reference.

image1114×92 4.63 KB

image1366×768 107 KB

ReadDataFromExcel.zip (5.7 KB)

Set active cell before starting the loop

image1066×481 38.7 KB

and then insert the value in the cell below

image984×366 27.3 KB

Thanks @ashapkina.