private void button1_Click(object sender, EventArgs e) { OleDbConnection excel = new OleDbConnection(@"Provider = Microsoft.ACE.OLEDB.12.0; Data Source = C:\Users\Administrateur\Desktop\Classeur1.xlsx; Extended Properties =""Excel 8.0;HDR=Yes;IMEX=1"""); OleDbCommand cmd = new OleDbCommand("select * from [Classeur1$]",excel); excel.Open(); DataTable tableau = new DataTable(); OleDbDataReader Reader = cmd.ExecuteReader(); tableau.Load(Reader); dataGridView1.DataSource = tableau; OleDbDataReader dr = cmd.ExecuteReader();
OleDbCommand cmd = new OleDbCommand("select * from [Classeur1$] where A1 Like Couc*",excel);mais sans aucune certitude.
21 févr. 2018 à 08:28