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.