Code Snippet for Fetching Data from Excel Using ADO.Net
How to use code snippet for fetching data from Excel using ADO.Net.
Today one of my team members asked me a very simple yet very important question:
"How could we fetch Excel Records using ADO.Net? Could you give me code snippet of same? "
I replied to him; it is pretty possible using OledDbConnection.
I told him to add the following reference.
I gave him the following straightforward code snippet. This function is:
public static DataTable GetItemsFromExcel1()
- Returning DataTable
- Reading XLS file called YourFile.xls from F Drive.
- Reading Sheet1
DataTable dt = new DataTable();
OleDbConnection excelConnection = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;"
+ @"Data Source=F:\YourFile.xls;"
+ @"Extended Properties=""Excel
OleDbDataAdapter dbAdapter =
("SELECT * FROM [Sheet1$]", excelConnection);
After using this function in his code, he was very happy and paid my coffee bill...