/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

0 vote328 views1 answer
Regex path pattern
C#
46 votes410 views6 answers
Random number generator unity
C#Unity
1 vote316 views2 answers
C# get hwid
C#
-1 vote266 views6 answers
Automatic time complexity Calculator
C#
0 vote277 views1 answer
Unity gameobject visible to specific camera
C#
4 votes271 views1 answer
C# loop through datatable
C#
10 votes245 views2 answers
List<string,string> c#
C#
1 vote255 views1 answer
The CodeDom provider type "Microsoft.CodeDom.Providers.DotNetCompilerPlatform.CSharpCodeProvider, Microsoft.CodeDom.Providers.DotNetCompilerPlatform, Version=2.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" could not be located.
C#
0 vote269 views1 answer
C# reflection create generic type
C#
0 vote276 views2 answers
__dopostback
C#