How to find a certain string in an excel file and return its cell coordinates?

Help Activities
, ,
1

I have an excel file where I need to find a certain string in it and get it’s cell position. (column and row)

2

Try using LookUp Range Activity

1 Like
3

@wdescalsota,

Hope you’ve read excel and right now you have a data in datatable variable,

int rowNo = 2 (row starts from 2 except col)
For each row row in datatable {
if row(“yourcolname”).tostring.contains(abc) {
// here if you find correct value then exit loop, use row number whatever it would be
}
rowNo = rowNo + 1 (put value in increment manner)
}

Cheers,
Pankaj

4

Hi, I tried this, and somehow works when I include the range of the joined columns (eg. A1:F100) but when I try A1:A100 it doesn’t get the coordinates of the string. is it necessary to include the columns that is joined with the first column? First column is A and it is joined until column F.

5

Okay…

Can you just scan this link as below? example are given and activities name to install.

Cheers,
Pankaj

1 Like
6

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.