How to find the cell position in excel

Help Studio
1

In attached Sheet “CIDF”, i want to find the cell position (Highlighted in yellow color) in excel. here i am reading Column E through “For Each Row” (row(4).ToString). so i want to find the position of column E one by one. please help me out. Thanks in advance.

image
image1366×768 105 KB

2

like E2 and E3 like wise?

3

@Pradeep_Shiv : Yes!!!

4

i’m attaching you the sample workflow you can go through!
cheers @baalajee_kSequence1.xaml (11.3 KB)

5

@Pradeep_Shiv: Will check it and let u know. Thx :slight_smile:

1 Like
6

Hi @baalajee_k

Use dt.rows.indexof(row)+2

Thanks
Ashwin S

7

instead of “-MD” you can pass your row(4).ToString

8

@Pradeep_Shiv: I checked but its giving cell value horizontal like A2, B2,C2,D2… so…on…
but i want like
E2, E3, E4, E5, E6

9

well you can do one thing!
get that particular column values and store it in a list!
and loop through that list and pass that column value one by one you’ll get the expected output!
cheers
@baalajee_k

10

@Pradeep_Shiv : I am new to excel activity work, can you guide me how to get particular column values and store it in a list and loop through that list and pass that column value one by one…

11

can you share me your excel i can do it for you!
cheers
@baalajee_k

12

Book1.xlsx (10.8 KB)

@Pradeep_Shiv : Please find the attachemnt

13

@Pradeep_Shiv: Can you tell the procedure or provide workflow on tomorrow ?