C#读取excel指定行的某些数据问题?

string MyExcel = "2008毕业生档案投递正稿.xls";

            DataTable dt = new DataTable();

            string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties='Excel 8.0;HDR=YES;IMEX=1;';" + "Data Source=" + MyExcel + ";";

            OleDbConnection connection = new OleDbConnection(strConnection);

            connection.Open();

            try

            {

                string str = "Select * from [Sheet1$]　where F1='220'";

                OleDbDataAdapter adapter = new OleDbDataAdapter(str, connection);

                adapter.Fill(dt);

            }

            catch

            {

                dt = null;

            }

            finally

            {

                connection.Close();

            }





            DataRow[] dr = dt.Select(" F1='220'");//找到你需要的行

string MyExcel = "2008毕业生档案投递正稿.xls";

            string MySheet = "Sheet1";

            OleDbConnection MyConnection = new OleDbConnection("Provider=Microsoft.Jet.OLEDB.4.0;Data source=" + MyExcel + ";Excel 8.0;HDR=YES");

            string MySQL = "SELECT * FROM ["+MySheet+"$]";  //"SELECT * FROM ["+MySheet+"$]";

            OleDbCommand MyCommand = new OleDbCommand(MySQL, MyConnection);

            OleDbDataAdapter MyAdapter = new OleDbDataAdapter(MyCommand);

            DataSet MySet = new DataSet();

            MyAdapter.Fill(MySet);

           this.dataGridView1.DataSource = MySet.Tables[0];

OleDbConnection objConn = null;

DataSet data = new DataSet();

try

{

string strConn = @"Provider=Microsoft.ACE.OleDb.12.0;Data Source=c:"待发工资.xlsx;Extended Properties='Excel 12.0;HDR=YES'";//IMEX=1为只读

//"Provider=Microsoft.Jet.OleDb.4.0;data source=c:"待发工资.xlsx;Extended Properties=""Excel 12.0;HDR=YES;IMEX=1""";

                objConn = new OleDbConnection(strConn);

objConn.Open();

//System .Data . DataTable schemaTable = objConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, null);

//int SheetIndex = 0;

//string tableName = schemaTable.Rows[SheetIndex][2].ToString().Trim();



string strSql = "Select   *   From   [Sheet1$]";

OleDbCommand objCmd = new OleDbCommand(strSql, objConn);

OleDbDataAdapter sqlada = new OleDbDataAdapter();

sqlada.SelectCommand = objCmd;

sqlada.Fill(data);

string str = "";

for (int i = 0; i < data.Tables[0].Rows[0].ItemArray.Length; i++)

{

str += data.Tables[0].Rows[0].ItemArray[i].ToString() + ".";

}

MessageBox.Show(str);

objConn.Close();

}

catch (Exception ex)

{

objConn.Close();

Console.WriteLine(ex.Message.ToString());

}