string constr = @"Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + textBox1.Text + @";Extended Properties=""Excel 12.0 Macro;HDR=YES;ImportMixedTypes=Text;TypeGuessRows=0"""; OleDbConnection con = new OleDbConnection(constr); //specific cell 1 - product "code" OleDbDataAdapter sda = new OleDbDataAdapter("Select * From [ARTIGOS$A" + textBox3.Text + ":A" + textBox3.Text + "]", con); //specific cell 2 - product "description" OleDbDataAdapter sdb = new OleDbDataAdapter("select * From [ARTIGOS$B" + textBox3.Text + ":B" + textBox3.Text + "]", con); //specific cell 3 - product "price" OleDbDataAdapter sdc = new OleDbDataAdapter("Select * From [ARTIGOS$I" + textBox3.Text + ":I" + textBox3.Text + "]", con); DataTable dt = new DataTable(); DataTable dt2 = new DataTable(); DataTable dt3 = new DataTable(); sda.Fill(dt); sdb.Fill(dt2); sdc.Fill(dt3); dataGridView1.Rows.Add(); dataGridView1.Rows[0].Cells[0].Value = dt; dataGridView1.Rows[0].Cells[1].Value = dt2; dataGridView1.Rows.Add(); dataGridView1.Rows[0].Cells[2].Value = textBox2.Text; dataGridView1.Rows[0].Cells[3].Value = dt3;
A...:A...
B...:B...
dataGridView1.Rows[0].Cells[1].Value = dt2;
dataGridView1.DataSource = dt2;
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)