How to find same values from different cell using C#

Question

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.

Leon D · 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);

Nilesh Shah · Answer

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.

Revathi Parvathi · Answer

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.

Leon D · Answer

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.