/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 vote191 views1 answer
UnityEngine.Transform.get_position () (at <a0ef933b1aa54b668801ea864e4204fe>:0) Gamekit3D.MeleeWeapon.BeginAttack (System.Boolean thowingAttack)
C#
0 vote191 views7 answers
Python to php converter online
C#
1 vote205 views1 answer
Compile in one single exe c#
C#
5 votes193 views1 answer
How to refer parent class unityu
C#Unity
0 vote194 views1 answer
How to start a timer in c# forms application
C#
0 vote207 views1 answer
C# restore form
C#
0 vote179 views1 answer
Pause and resume thread C#
C#
0 vote190 views1 answer
C# base vs this
C#
2 votes197 views10 answers
Format of money value in c#
C#
2 votes249 views1 answer
C# cancellationtoken example
C#