asp.net 读取Excel2007

               

                string conn = "Provider=Microsoft.Ace.OleDb.12.0;"
                                + " Data Source='文件路径';"
                                + "Extended Properties='Excel 12.0;HDR=YES;IMEX=1;'";
                OleDbConnection objConnection = new OleDbConnection(conn);
                objConnection.Open();
                OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from [sheet1$]", objConnection);
                DataSet ds = new DataSet();
                myCommandd.Fill(ds, "[sheet1$]");
                objConnection.Close();