string strConn;

                strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + filePath + ";Extended Properties='Excel 8.0;HDR=False;IMEX=1'";

                OleDbConnection OleConn = new OleDbConnection(strConn);

                OleConn.Open();

                System.Data.DataTable sheetNames = OleConn.GetOleDbSchemaTable(System.Data.OleDb.OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });//获得Excel表的架构信息

                String sql = "SELECT * FROM  [" + sheetNames.Rows[0]["TABLE_NAME"] + "]";//可是更改Sheet名称，比如sheet2，等等    

                OleDbDataAdapter OleDaExcel = new OleDbDataAdapter(sql, OleConn);

                DataSet OleDsExcle = new DataSet();

                OleDaExcel.Fill(OleDsExcle);

                OleConn.Close();

                return OleDsExcle;