Get the data from column in the same row

Help
1

Hi,

I have a for each row loop. If condition is met in for example row 3 then I would like to get the value from cell f3. I have something like this in read cell activity: “f”&senderEmailsDT.Rows.IndexOf(row) but here I get f0 cell, not f3. How to get the number of row that i’m currently in?

Regards,
M

2

To the get index of row u are working

There is index property panel of for each row.

Create a varaible there which store the row index of current iteration.
For eg if want to read the A1 Cell which has row index 0

Then in general for any rowindex index

Then the cell should.be written as

“A”+(index+2).ToString

Hope the idea helps you

Regards

Nived N :robot:

Happy Automation :relaxed::relaxed: