Find cell with String Value and get no. of row, name of column

[arivu96 (Arivazhagan A)]

HI @AKY,

can you go through this post, its may be helpful for you. @ClaytonM

Find a cell position in Data Table

Hi Tomas, Yes you can do this. You will need the row number within the DataTable and the column Index. To get the row number, you can simply have a counter inside a loop (but that can be slow). If you are using vb.net to pull out the row that contains a word then you can use the .IndexOf() function, I believe. For Example, rowIndex =(datatableVariable.Rows.IndexOf(datatableVariable.AsEnumerable().Where(Function(row) row(0).ToString.Contains(“word”)).ToArray()(0))+1).ToString Then you need …

Regards,
Arivu