学步园

string strSheetName = "house";

        //源的定义
        string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + Server.MapPath(filename) + ";Extended Properties ='Excel 8.0;HDR=NO;IMEX=1'";

        //Sql语句
        string strExcel = "select * from  [" + strSheetName + "$]";

        //定义存放的数据表
        DataSet ds = new DataSet();

        //连接数据源
        OleDbConnection conn = new OleDbConnection(strConn);

        //适配到数据源
        OleDbDataAdapter adapter = new OleDbDataAdapter(strExcel, conn);
        adapter.Fill(ds, "res");