How to find row number in worksheet based on search string in c#.net

Gani tpt · Jan 4, 2019

I am searching some string in the excel worksheet column. This is working perfect.

But, i want to get the row number of the search string in the worksheet...?

string colToCheck = "C40:C90"
string SearchNo = "ABC-201";
Excel.Range resultRange;
colRange = XLWorkSheet1.Range[colToCheck];//get the range object where you want to search from

resultRange = colRange.Find(

What: SearchNo,

LookIn: Excel.XlFindLookIn.xlValues,

LookAt: Excel.XlLookAt.xlPart,

SearchOrder: Excel.XlSearchOrder.xlByRows,

SearchDirection: Excel.XlSearchDirection.xlNext

);

How to find row number in worksheet based on search string in c#.net

Gani tpt

Guest