/C#/How to find the text position in excel in c#

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();

How to find the text position in excel in c#

foreach (var worksheetCell in workSheet.Cells)
                {
                    if (worksheetCell.Value != null)
                    {
                        if (worksheetCell.Value.ToString() == "EMP 563")
                        {
                            var worksheetCellFullAddress = worksheetCell.Address;
                            Console.WriteLine(worksheetCellFullAddress);
                        }
                    }

                }

Similar codes

1 vote208 views1 answer
Set textbox colour to transparent c#
C#
0 vote270 views1 answer
Top down movement unity
C#Unity
3 votes208 views1 answer
Get type of variable c#
C#
1 vote197 views1 answer
Get text after word C#
C#
0 vote210 views2 answers
C# wpf control to windw size
C#
-1 vote188 views1 answer
C# recursion formula for the factorial
C#
0 vote243 views1 answer
Get all files in all subdirectories c#
C#
0 vote196 views1 answer
Weakreference tryget c#
C#
1 vote184 views1 answer
Remove last instance of string c#
C#
1 vote207 views1 answer
Unity c# struct
C#