/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 vote171 views1 answer
How to configure visual studio for unity
C#Unity
1 vote112 views1 answer
Removing illlegal char from filename
C#
-1 vote167 views1 answer
Rotate along normal unity
C#Unity
0 vote125 views1 answer
Sucess messages in c#
C#
0 vote128 views1 answer
Update a file where there is a keyword c#
C#
0 vote115 views1 answer
Web client ignore ssl error
C#
2 votes131 views1 answer
Get current computer name C#
C#
7 votes121 views1 answer
How to reference function in unity
C#
0 vote140 views1 answer
How to check datagridview cell is null or empty
C#
-1 vote124 views1 answer
How to create a random vector2 in unity
C#