ThinkPHP 3.2.3 Excel文件内容导入数据库

//导入用户数据
public function excel(){
    header("Content-Type: text/html; charset=utf-8");
    import("Org.Util.PHPExcel");
    $excel = new \PHPExcel();
    //excel表名
    $filename = "./a.xlsx";
    //声明team.xlsx的如果是xls则倒入PHPExcel_Reader_Excel5
    import("Org.Util.PHPExcel.Reader.Excel2007");
    $PHPReader=new \PHPExcel_Reader_Excel2007();
    $PHPExcel=$PHPReader->load($filename);
    //获取第一个工作表，获取后面的一次＋1
    $currentSheet=$PHPExcel->getSheet(0);
    //获取总行数
    $allColumn = $currentSheet->getHighestColumn();
    $allRow = $currentSheet->getHighestRow();
    $mresult = true;
    for($currentRow = 1;$currentRow<=$allRow;$currentRow++){
        $member = D("member");
        $member->startTrans();
        $data ['member_name'] = $currentSheet->getCell('A'.$currentRow)->getValue();
        $data ['member_password'] = md5(md5("123456"));
        $data ['member_mobile'] = 13888888880+$currentRow;
        $data ['member_avatar'] = "/Uploads/avatar/a_".$currentRow.".jpg";
        $mresult=$member->add($data);
        if($mresult){
            $member->commit();
            echo '<div style="width:700px;">用户名：'.$data['member_name'].'密码:'.$data ['member_password'].'<div>';
            flush();
        }else {
            $member->rollback();
            echo '数据添加错误在'.$currentRow.'行';
            flush();
        }
    }
}

Excel类库下载：http://download.csdn.net/download/song_121292057/7955907