C#连接EXCEL

 try
            {
                OleDbConnection myConn = new OleDbConnection(@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:/学习资料/ACCPS2笔试机试/ACCPS2笔试/20070114笔试S2/答案.xls;Extended Properties=Excel 8.0;");
                myConn.Open();
                OleDbDataAdapter thisAdapter = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", myConn);
                OleDbCommandBuilder thisBuilder = new OleDbCommandBuilder(thisAdapter);
                DataSet thisDataSet = new DataSet();
                thisAdapter.Fill(thisDataSet, "ExcelInfo");
               this.dataGridView1.DataSource=thisDataSet.Tables[0];
                myConn.Close();
            }
            catch (OleDbException ex)
            {
                MessageBox.Show(ex.Message);
            }