/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

3 votes159 views1 answer
Countdown timer c# unity
C#
0 vote154 views2 answers
Install sticky notes in ubuntu
C#
6 votes111 views1 answer
C# ide online
C#
11 votes210 views2 answers
Unity 2d raycast mouse
C#Unity
1 vote249 views1 answer
In what occasions do you use void update and fixedupdate C# unity
C#Unity
3 votes155 views3 answers
How to move mouse with c#
C#
1 vote162 views3 answers
Visual studio reinstall all nuget packages
C#
1 vote161 views4 answers
Check if a string is a palindrome
C#
2 votes171 views1 answer
2d shooting unity
C#Unity
5 votes182 views2 answers
Vscode c# how to change to externial terminal
C#