How to find row index of string in excel

[minal.patil]

Hello,

How to find row index of particular string in excel.

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
You can follow this screenshot

Thanks

[Rounak_Kumar1 (Rounak Kumar)]

Hey,
follow this

[Gangadhar_Athili]

DT.Asenumerable.Tolist.Findindex(Function(r) r(ColumnName).To string.Equals(String_Variable))

[minal.patil]

I get string value dynamically from one excel and search on another excel

[Rounak_Kumar1 (Rounak Kumar)]

You can use lookup Data Table ACtivity

Thanks

[minal.patil]

vDTData.Asenumerable.Tolist.Findindex(Function(r) r(Company Code).Tosrting .Equals(str_value))

it gets error on tostring

[Rounak_Kumar1 (Rounak Kumar)]

Here you can see
DataTable- In which excel you want to search-ReadRange-DT1
LookUpValue- That value you are searching For
ColumnIndex- In which column you are looking for Index starts from 0
CellValue-Output- which value you want
ColumnIndex- Refrence ColumnIndex
Thanks,
Rounak

[minal.patil]

it get ‘-1’ row index

[RK_0 (RK)]

Hi,
Follow this video about row index

How to get the Row Index in a DataTable in UiPath - Tutorial

[minal.patil]

Thanks it’s solve