How to find the particular cell value position in datatable

[PAD]

Hi @sandhyak9
If you read your first sheet with Read range, so the output will be a datatable, and then for each row you use Get row item, you can use later the below threads:

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

Thank Arivu, I am trying to get position’s information of cell have title “S.TL” by message box like below. Now I can only find value text cell by each row and get no. of column (But not correct, first cell show to me message box is “column5”). [Capture] If we have correct no. of column, how to change to name such as “I10” or get no. of row or name of column. This my file is testing. TestFindPosition.xaml (14.2 KB) Please help to check. Thanks

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 …

for v2018.2:

Activities - Lookup Data Table