读取Excel表

private DataSet CreateDataSource()
        {
            string strCon;
            strCon = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=E://源代码//ShiXiWang//admin//source//Wry.xls; Extended  Properties=Excel 8.0;";
            OleDbConnection olecon = new OleDbConnection(strCon);
            OleDbDataAdapter myda = new OleDbDataAdapter("SELECT   *   FROM   [Wry$] ", strCon);
            DataSet myds = new DataSet();
            myda.Fill(myds);
            return myds;
        }