/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 vote232 views1 answer
Remove compoennt unity
C#
0 vote255 views1 answer
How to make projectile track and go to specified enemy in unity
C#
0 vote246 views1 answer
Wpf how to focus on element
C#
10 votes237 views2 answers
How to set a color of text in unity 2020 script
C#
0 vote234 views1 answer
How to input parameters in c#
C#
0 vote286 views1 answer
C# see if list contains any duplicates
C#
0 vote239 views1 answer
How to assign rds CAL for users
C#
0 vote231 views1 answer
Reverse Coding Challenge 1
C#
0 vote211 views1 answer
Enemy turret one direction ahooting script unity 2d
C#
1 vote226 views1 answer
How to index ireadonlycollection c#
C#