Import Data from Excel to DataGridView in C#

Thanks for this sample

Good One. Thanks

How to compare the data from excel to database? for example: if the name "JOHN" is imported from the excel file to database then when you import it again the message box will show that the data contain in the excel file is already imported

How do I feed data to third party forms from Excel list?

Thanks so much, Ankur. My excel workbook has has only one sheet and I would like to select contents in A1:A50, B1:B50, C1:C50 and D1:D50. I would appreciate your help. Would like to follow you on twitter. I'm @bigcaptsammy

how can i import image from excel file into datagridview ?

Ken H

Provider is not found. The program may not be installed correctly.

hello Ankur sir, the above code is not working properly...the error is "Provider cannot be found. It may not be properly installed." and the sheet data is not view can u help me...thx in advance....

--------------------------- --------------------------- Provider cannot be found. It may not be properly installed. --------------------------- OK ---------------------------

Thank you...........

the use for xlsx not require change, only change the filter *.xls|*.xlsx that all to do it.

can you suggest me the code change for .xlsx file...

i want to load external sql database file to my project and want to show it on datagrid view and when the database change want to change in datagrid view in runtime how can i do that. plz help

why i cant download zip file?

Current provider will be used only with .xls file not with .xlsx if you are using .xlsx file then please let me know i will suggest you the changes according to that. Ankur

modified ur code more to get past that error: private void Select_Tables_Load(object sender, EventArgs e) { int tCount = Tables.Count(); if (!DataTables) { if (Tables != null) { for (int tables = 0; tables <= Tables.Length-1; tables++) { if (Tables[tables] != null) { try { ListViewItem lv = new ListViewItem(); lv.Text = Tables[tables].ToString(); lv.Tag = tables; lstViewTables.Items.Add(lv); } catch (Exception ex) { MessageBox.Show("Select_Tables_Load Tables - " + ex.Message.ToString()); } } } }

got past those two errors but there is this one now: private void Select_Tables_Load(object sender, EventArgs e) { if (!DataTables) { if (Tables != null) { for (int tables = 0; tables < Tables.Length; tables++) { try { ListViewItem lv = new ListViewItem(); lv.Text = Tables[tables].ToString(); lv.Tag = tables; lstViewTables.Items.Add(lv); } catch (Exception ex) { MessageBox.Show("Select_Tables_Load Tables - " + ex.Message.ToString()); } produces this error as the catch: Object reference not set to an instance of an object

objSelectTable.ShowDialog(this); //shows form but nothing populated in list view and I've got a spreadsheet with two workbooks -- not sure why they are not showing up in the select table listview

error: External table is not in the expected format oConn.Open("Provider=Microsoft.Jet.OleDb.4.0; Data Source = " + strFileName + "; Extended Properties = \"Excel 8.0;HDR=Yes;IMEX=1\";", "", "", 0);

Thank you bro. Awesome

you need to set Target Platform X86 instead of Any CPU.

I have Message : "Provider cannot be found. It may not be properly installed." what should I do ? any one can help ?

Thanks

Nice one really awesome

I already added the reference "Microsoft ADO Ext. 2.8". But it still doesn't work...

Thanks a lot..... Nice Coding and Simple.....

can this program support both "xls" and "xlsx"? how i can implement it Thanks Shuky: [email protected]

Thanks for the great article. What if I want to select a specific range of cells from a specific sheet? Say selecting the range [A1:B45] from the sheet FAIL$. Thank you again, Ali

if i m using this library System.Windows.Documents & System.Windows.Controls this two library Show Following Error 1 The type or namespace name 'Documents' does not exist in the namespace 'System.Windows' (are you missing an assembly reference?) D:\Nishant\Studies\C#\Windows Forms Application\123Application\123Application\Form1.cs 9 22 123Application & Error 2 The type or namespace name 'Controls' does not exist in the namespace 'System.Windows' (are you missing an assembly reference?) D:\Nishant\Studies\C#\Windows Forms Application\123Application\123Application\Form1.cs 10 22 123Application

i having combo box,listbox and (Add) button & i want to show excel data within combo box who show and read header line if i select value this value add in listbox plz can u help me

?????

hi how to delete a row of gridview and then it deleted from excel?

have the same error....as discussed aboveee......what to do????

sir if i run the example program it prompt that the "Provider cannot be found.it may not properly installed."what can i do to run this properly