thinkphp5,thinkphp3.2与phpexcel完美结合

赚点积分哈

支持联合查询,联合查询来个例子吧

$list = Db::table("system_case_info") ->alias('a')
    ->join('system_personal b','a.personal_id = b.id','LEFT')
    ->field('b.*,a.*')
    ->where($condition)
    ->group('a.id')
    // ->order('user_id desc')
    ->limit($Page->firstRow.','.$Page->listRows)
    ->select();
$objPHPExcel = new \PHPExcel();
$objWriter = new \PHPExcel_Writer_Excel5($objPHPExcel);
//设置sheet名称
$sheets=$objPHPExcel->getActiveSheet()->setTitle('demo');
//设置sheet列头信息
$objPHPExcel->setActiveSheetIndex()->setCellValue('A1', '案件编号')->setCellValue('B1', '申请城市')->setCellValue('C1', '客户姓名')->setCellValue('D1', '手机号')->setCellValue('E1', '还款状态')->setCellValue('F1', '逾期天数')
    ->setCellValue('G1', '案件金额')->setCellValue('H1', '案件手数')->setCellValue('I1', '佣金比例%')->setCellValue('J1', '还款日期')->setCellValue('K1', '放款日期')->setCellValue('L1', '机构名称')->setCellValue('M1', '状态')
    ->setCellValue('N1', '是否催办')->setCellValue('O1', '催收反馈')->setCellValue('P1', '催收方式')->setCellValue('Q1', '案件评分');
$i=2;
foreach($list as $v){
    //设置单元格的值
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('A'.$i,$v['case_number']);//案件编号
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('B'.$i,$v['local_home_address']);//申请城市
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('C'.$i,$v['name']);//客户姓名
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('D'.$i,$v['mobile_no']);//手机号
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('E'.$i,$v['pay_status']);//还款状态
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('F'.$i,$v['overdue_days']);//逾期天数
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('G'.$i,$v['contract_amount']);//案件金额
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('H'.$i,$v['hand_number']);//案件手数
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('I'.$i,$v['commission_rate']);//佣金比例%
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('J'.$i,$v['promise_time']);//还款日期
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('K'.$i,$v['loan_date']);//放款日期
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('L'.$i,$v['principal_id']);//机构名称
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('M'.$i,$v['collection_status']);//状态
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('N'.$i,$v['collection_status']);//是否催办
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('O'.$i,$v['followup_back']);//催收反馈
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('P'.$i,$v['assist_way']);//催收方式
    $sheets=$objPHPExcel->getActiveSheet()->setCellValue('Q'.$i,$v['score']);//案件评分
    $i++;
}

 foreach ($count_venue as $k=>$v) {
            $i++;//编辑时候自增
            $sheets = $objPHPExcel->getActiveSheet()->setCellValue('H' . $i, $v['name']);
            $sheets = $objPHPExcel->getActiveSheet()->setCellValue('I' . $i, $v['venue_number']);
            $sheets = $objPHPExcel->getActiveSheet()->setCellValue('J' . $i, $v['people_number']);
            $sheets = $objPHPExcel->getActiveSheet()->setCellValue('K' . $i, $v['people_number_today']);
        }

Thinkphp5.0导入导出excel实例DEMO下载,导出来的文件可以修改后再导入进去，然后再导出来，看看数据是否新增了

​​​​