Regarding to know if data exist in excel

Question

I want to know if data exist in a excel without opening it.please give me a solution in c#.

Amit Gupta · Accepted Answer

Use oledb connection for this

Amit Gupta · Answer

@Manoj
Using Interop.Excel is unmanaged code and is much slower than OleDB connection. Where Interop took 30 sec for a job then it can be done within 3 sec in OleDb.

Amit Gupta · Answer

You can get many on the web
https://www.codeproject.com/Articles/1088970/Read-Write-Excel-file-with-OLEDB-in-Csharp-without

Manoj Bhoir · Answer

Hi,   You can check this sample project.   https://www.c-sharpcorner.com/UploadFile/6b8651/read-excel-file-in-windows-application-using-C-Sharp/

Sourav Sahu · Answer

Okey.do you have a sample or demo code of how to use this??