Locating a cell from text string

[flipperyfish]

Hi,

I need to locate a single cell based on a known text string that will be in it. Please could you point me in the right direction if this is possible?

Thanks,

Andy

[Gary.zhang]

Hello,

Sorry for late reply as weekend.
Thanks for your inquiry.
Following code example demonstrates how to locate a single cell based on a known text string for your reference.

Code: Select all

Workbook book = new Workbook();
book.LoadFromFile("test.xlsx");
foreach(CellRange cell in book.Worksheets[0].Cells)
            {
                if(cell.Text=="test")
                {
                    Console.WriteLine(cell.RangeAddress);
                }
            }
Console.ReadLine();


If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team

[Benjamin Du]

Hello,

Have you tested the code provided by my colleague Gary? Has the issue been resolved?
Could you please give us some feedback if convenience?

If you have any questions, welcome to get it back to us.

Regards,
Benjamin
E-iceblue support team

[flipperyfish]

Hi,

The solution works perfectly, thanks very much.

Andy

[Gary.zhang]

Glad to hear that. If there are any questions, welcome to get it back to us.
Sincerely,
Gary
E-iceblue support team