把Excel导入DataGridView

            OpenFileDialog filedialog = new OpenFileDialog();
            filedialog.Filter = "Excel文件|*.xls";
            filedialog.ShowDialog();
            string filename = filedialog.FileName;
            string strconn = @"Provider=Microsoft.ACE.OleDb.12.0;Data Source=" + filename + ";Extended Properties='Excel 12.0;HDR=YES;IMEX=1'";       
            DataSet dt = new DataSet();
            string sql="Select * from [Sheet1$]";
            OleDbDataAdapter da = new OleDbDataAdapter(sql, strconn);          
            da.Fill(dt);
            dataGridView2.DataSource = dt.Tables[0];