string strConn = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + FilePath + ";Extended Properties='Excel 8.0;HDR=Yes;IMEX=1;'";
            OleDbConnection conn = new OleDbConnection(strConn);
            conn.Open();
            OleDbCommand comm = new OleDbCommand("SELECT*FROM[Sheet1$]", conn);
            OleDbDataReader myReader = comm.ExecuteReader(CommandBehavior.CloseConnection);

posted on 2010-03-30 13:21  freedom831215  阅读(194)  评论(0编辑  收藏  举报