Hi everyone, please help me asap. Im writing a C# application to open an Excel file to retrieve data from it (I use using VS.NET). If I open the excel file using MS Excel, I can easily find a cell that meets some criteria by using Find/Replace function of MS Excel. It would be excellent if I can have the same function when I use C# to read the file, otherwise it would take forever to retrieve all data that I want (I had to write code to look up in every single cell in every worksheet-_-!). Is it possible to call Find/Replace function in Excel in C#? If yes, please write a sample code for me, that would save my life. Thousands of thanks for all of you who're reading this.
0 · ·