Import Data from Excel to DataGridView in C++.net

Question

I need an example please, if anyone can help me with this...

JUAN AGUI · Answer

Thanks everyone for help me up with this... reading your codes, i came up with this for visual c++... By the way, it works.!! Don't forget to declare this at the begin using namespace System::Data::OleDb; public: void CreateOleDbConnection() { try { String ^myQuery = ""; OleDbConnection^ myConnection = gcnew OleDbConnection(); OleDbCommand^ myCommand = gcnew OleDbCommand(); DataSet^ myDataSet = gcnew DataSet(); OleDbDataAdapter^ myDataAdapter = gcnew OleDbDataAdapter(); DataTable^ myDataTable = gcnew DataTable(); myConnection->ConnectionString = "provider=Microsoft.Jet.OLEDB.4.0; " + "data source='" + txtFile->Text + " '; " + "Extended Properties=Excel 8.0;"; myConnection->Open(); myQuery = "select * from [sheet1$]"; myCommand = gcnew OleDbCommand(myQuery, myConnection); myDataSet = gcnew DataSet(); myDataAdapter = gcnew OleDbDataAdapter(myCommand); myDataAdapter->Fill(myDataSet,"[sheet1$]"); myConnection->Close(); dgvFile->DataSource = myDataSet; dgvFile->DataMember = "[sheet1$]"; } catch(System::Data::SqlClient::SqlException ^ex) { MessageBox::Show(ex->Message, "SQL Query Failed"); } } private: System::Void button1_Click(System::Object^ sender, System::EventArgs^ e) { OpenFileDialog ^ openFileDialog1 = gcnew OpenFileDialog(); openFileDialog1->Filter = "allfiles|*.xls"; openFileDialog1->Title = "Seleccionar archivo Excel"; // If the user clicked OK in the dialog and a .xls file was selected, open it. if (openFileDialog1->ShowDialog() == ::DialogResult::OK) { txtFile->Text = openFileDialog1->FileName; CreateOleDbConnection(); // Assign the cursor in the Stream to // the Form's Cursor property. //this->Cursor = new //System::Windows::Forms::Cursor( //openFileDialog1->OpenFile()); } }

Satyapriya Nayak · Answer

Hi Juan, Here is an example in Csharp using System; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Linq; using System.Text; using System.Windows.Forms; using System.Data.OleDb; namespace Retrieving_excel_data_to_combobox { public partial class Form1 : Form { public OleDbConnection con; public void pintu(string s) { con = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; " + "data source='" + s + " '; " + "Extended Properties=Excel 8.0;"); } public OleDbCommand com; public DataSet ds; public OleDbDataAdapter oledbda; public DataTable dt; public string str; public Form1() { InitializeComponent(); } private void btnbrowse_Click(object sender, EventArgs e) { OpenFileDialog openfiledialog1 = new OpenFileDialog(); openfiledialog1.ShowDialog(); openfiledialog1.Filter = "allfiles|*.xls"; TextBox1.Text = openfiledialog1.FileName; } private void btndisplay_Click(object sender, EventArgs e) { pintu(TextBox1.Text); try { con.Open(); str = "select * from [sheet1$]"; com = new OleDbCommand(str, con); ds = new DataSet(); oledbda = new OleDbDataAdapter(com); oledbda.Fill(ds, "[sheet1$]"); con.Close(); DataGridView1.DataSource = ds; DataGridView1.DataMember = "[sheet1$]"; } catch (Exception ex) { MessageBox.Show(ex.Message); } } } } Thanks

George eric · Answer

Hi, You can check the following blogspot. Easy Solution to Import Excel to Datatable . Though it is doing in C#.NET, it is still a good example, as there is not many examples that import excel to datagridview. Yet I might be wrong, please forgive.

Import Data from Excel to DataGridView in C++.net

Answers (3)