find out the word in Excel

Question

I have a WPF contains a text box and I also have an excel file contains of thousands of Employee names.if i entered a specific name in my search text box in WPF then it run and open that excel file and highlight the name entered in excel file. (ex) I have a excel file contain some employee Names if i entered  raj in my text box and I run the program then i want to open the excel file and highlight the respected cell.Can anyone suggest me how can i do that?

alice yang · Answer

Hi dinesh You could try this free Excel API: http://visualstudiogallery.msdn.microsoft.com/81c33294-eee9-4683-9cee-a5714cfebf34 And refer to the following link to find and highlight data in Excel: http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Find-and-Highlight-Find-and-Highlight-Data-in-Excel-with-C-VB.NET.html

Vishal Jadav · Answer

Hi Are you using Excel interop DLLs ? If yes then there is method to find the text in given worksheet. Hope it helps. Thanks...

Esakki Muthu · Answer

Hi Dinesh The below link might help you https://msdn.microsoft.com/en-us/library/e4x1k99a.aspx