how to find the text position in excel in c#
int rowStart = worksheet.Dimension.Start.Row;
int rowEnd = worksheet.Dimension.End.Row;
string cellRange = rowStart.ToString() + ":" + rowEnd.ToString();
var searchCell =from cell in worksheet.Cells[cellRange] //you can define your own range of cells for lookup
where cell.Value.ToString() == "Total"
select cell.Start.Row;
int rowNum = searchCell.First();