How to find same values from different cell using C#

Revathi Parvathi

Microsoft.Office.Interop.Excel.Range Range_Number_Phone;

Range_Number_Phone = xlWorkSheet.UsedRange.Find("Phone");

This code finds first values only.it can't find another word.How is it possible?Please help me.

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Leon D8y ago
Accepted answer
Free Spire.XLS makes this thing fairly simple. You can reference Free Spire.XLS dll from NuGet Package Manager and use the following code:
Workbook workbook = new Workbook();
workbook.LoadFromFile("Input.xlsx");

Worksheet sheet = workbook.Worksheets[0];

//Find all "Phone"
CellRange[] ranges = sheet.FindAllString("Phone", false, false);

foreach (CellRange range in ranges)
{
    //Do things you want
}

workbook.SaveToFile("Output.xlsx", ExcelVersion.Version2013);
Leon D8y ago
I just ran the code but it worked well on my side. I supose you only add the spire.xls.dll, please remove it and then reference all the dlls: "Spire.Common.dll" "Spire.License.dll" "Spire.Pdf.dll" "Spire.XLS.dll" from the bin folder into your project and try again. If it still does not work, let me know.
Revathi Parvathi8y ago
Hi Leon,

Below mentioned error occurs in the line no 1.

Workbook workbook = new Workbook();

"The type initializer for 'spr840' threw an exception"

Please help me.
Nilesh Shah8y ago
Find will return the first result only. because this function is created by Microsoft in such a way.

use find next to get next search result, there is no find all function currently.