Skip to main content

Posts

Showing posts from February, 2012

C#: Import Excel and CSV file into DataTable using C#

It's one of the main hurdles any developer will face during development life cycle. We have Excel sheet or CSV sheet and client want to save data of Excel/CSV file to be saved in database with the help of C# coding. Here I'll explain how we can import Excel and CSV file and then create data-table of file records. We can then easily use this data-table to insert record in DB (here I'm not explaining how to insert record to DB).
Here is function to import excel file and return DataTable:
Namespace required are: System.Data and System.Data.OleDb;
privateDataTable GetExcelSheetdata() { DataTable dt = newDataTable();
try     { // Url of file to be imported. var url = @"c:\test.xls";
// Create OleDB connection string. string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 12.0;""", url);
var query = String.Format("Select * from [{0}$]", "Sheet1"); //Creates and …