I have to find (TS) in my excel without knowing Index and after that it checking 'Up' text in another columns(it also without knowing index)

[shaik.muktharvalli1 (shaik muktharvalli)]

I have to find (TS) in my excel without knowing Index and after that it checking ‘Up’ text in another columns(it also without knowing index)

Thanks
Shaik Muktharvalli

[Anil_G (Anil Gorthi)]

@shaik.muktharvalli1

Please check this…it is the exact same requirement I believe

Get all cell numbers of a specific value found in Excel

With the assumptions we can rely on a datatable intOffset - reflecting the usage of headerline / 1 based index from excel intOffset = 1 strMatchValue = “aBc” arrCells = (From rix in Enumerable.Range(0, dtData.Rows.Count) From cix in Enumerable.Range(0, dtData.Columns.Count) Where dtData.Rows(rix)(cix).toString.Trim.ToUpper.Equals(strMatchValue.ToUpper) Let cl = UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(cix + 1) Let ci = (rix + intOffset).toString Select x = cl & …

Hope this helps

Cheers

[shaik.muktharvalli1 (shaik muktharvalli)]

Can You make some workflow please @Anil_G

[Anil_G (Anil Gorthi)]

@shaik.muktharvalli1

You just need to read the data into datatable and then use assign activities as specified in the post…please try the same and if there are any difficulties we can help.

Cheers