For each row typ into function

[artem1]

Good day,

I am building a robot which has to insert from an excel sheet A2:A300 the string into my Browser simultaneously it should insert the string from the same excel sheet B2:B300.
So with the first each row it insert A2 and B2
in the second execution A3 and B3.

My problem is now if I use For each row of the row A it does not counts with B.

My code looks like this:

The excel looks like this:

But it can´t write down Path because it not it owns Row.

I tried a for each loop in a for each loop but than the first value does not increase.

It has to be like a double for each… like for each IMONO and in the same time for each Weg
I don´t really know how to explain it…

Can someone assist me with it?
I need it as fast as possible.

Kind regards

[ppr (Peter Preuss)]

Double for each row

Good day, I have two excel sheets from where i read out the data. Now I would like to build a for each row of the first excel sheet it should type into a website the first entry of the first excel and the first entry of the second excel. After that it should go on with the second row of the first excel and the second row of the fist excel. My problem is if I use a for each row it can only give me the value back of which row i mentioned. So it can´t access the second excel sheet. My code loo…

[SowmyaLeo (Sowmya Sivakumar)]

@artem1

I think it would be sufficient to use one Read Range activity and set the range from A1:B300 (Check the property Add headers if the first row is a header).
Now the data table should have both the columns.
You can use the foreach row loop and row(0).ToString - to get first column value in the row and row(1).ToString to get the second column value and proceed further.

[artem1]

It works perfectly! Thank you!