.NET Tutorials

.NET Tutorials for Beginners

Import Excel file into DataGridView

Import Excel file into DataGridView using C#

string connectionString = String.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties=""Excel 8.0;HDR=YES;IMEX=1;""", txtPath.Text);

string query = String.Format("select * from [{0}$]", "Sheet1");

OleDbDataAdapter dataAdapter = new OleDbDataAdapter(query, connectionString);

DataSet dataSet = new DataSet();

dataAdapter.Fill(dataSet);

dataGridView1.DataSource = dataSet.Tables[0];

Download Source

Related posts:

1. Import CSV file into DataGridView
2. Export DataGridView to Excel
3. Export DataGridView to XML using C#
4. Export Data from DataGridView to CSV file
5. Export GridView to Excel in ASP.NET

6 Comments

1. Javed says:

   August 2, 2011 at 7:47 am

   Thanks for
   Import Excel file into DataGridView this code help me

   Reply
2. makb says:

   November 21, 2011 at 8:31 am

   this code helded me in importing excel xlsx file into datagrid but there is a problem, its ordering is different when it imports to data grid….

   anyone can tell me how i can import it in its original order???

   Reply
3. Warren says:

   December 20, 2011 at 2:02 am

   Hi guys! any idea how to save back the data in the datagridview back to the excel file??

   Reply
4. mikelantzelo says:

   April 24, 2012 at 4:40 pm

   thank you!!!!very nice and easy!!!

   Reply
5. Nirosha says:

   May 1, 2012 at 7:48 am

   Thanks Dear i was looking this its save my time

   Reply
6. Jignesh says:

   July 10, 2012 at 6:54 pm

   I can load the data but shows me an ” The ‘Microsoft.ACE.OLEDB.12.0′ provider is not registered on the local machine.” on dataAdapter.Fill(dataSet); …… InvalidOperation Exception was unhandled

   Please help out soon.

   Reply