/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

5 votes279 views3 answers
Unity 2d rotation
C#
0 vote310 views1 answer
No entity framework provider found for the ado.net provider with invariant name
C#
0 vote280 views1 answer
Visual studio import excel get document created date
C#
0 vote365 views1 answer
Create anchor tag dynamically c#
C#
0 vote325 views2 answers
How many days till christmas
C#
0 vote325 views1 answer
Unity stop velocity movement
C#Unity
28 votes306 views2 answers
C# file exist
C#
0 vote302 views1 answer
Is and as in c#
C#
0 vote316 views1 answer
Iis services in asp.net
C#
50 votes473 views4 answers
Unity how to load a scene
C#Unity