php导出俩个Sheet

public function actionExcel(){
        //设置内存
        ini_set("memory_limit", "2048M");
        set_time_limit(0);

        //去用户表获取用户信息
        $user = UserInfo::find()->where(['ui_id'=>1])->asArray()->all();
        $objectPHPExcel = new \PHPExcel();
        $objectPHPExcel->setActiveSheetIndex(0);
        //给Sheet设置名字
        $objectPHPExcel->getActiveSheet()->setTitle("报表统计");
        //设置表格头的输出
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('A1', '座席');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('B1', '工号');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('C1', '座席来电数');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('D1', '座席来电接听数');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('E1', '座席来电未听数');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('F1', '接通率');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('G1', '总接通量占比');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('H1', '总外呼数');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('I1', '外呼双方接听数');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('J1', '呼入总通话时间');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('K1', '呼入平均通话时长');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('L1', '外呼总通话时间');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('M1', '外呼平均通话时间');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('N1', '总登录时长');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('O1', '总置忙时长');
        $objectPHPExcel->setActiveSheetIndex()->setCellValue('P1', '总空闲时长');


        $n = 2;
        foreach ($user as $v){
            $objectPHPExcel->getActiveSheet()->setCellValue('A'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('B'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('C'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('D'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('E'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('F'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('G'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('H'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('I'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('J'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('K'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('L'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('M'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('N'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('O'.($n) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('P'.($n) ,$v['ui_id']);
            $n = $n +1;
        }
        $i = 2;
        $objectPHPExcel->createSheet();
        $objectPHPExcel->setActiveSheetIndex(1);
        //给Sheet设置名字
        $objectPHPExcel->getActiveSheet()->setTitle("满意度统计");
        $objectPHPExcel->setActiveSheetIndex(1)->setCellValue('A1', '座席');
        $objectPHPExcel->setActiveSheetIndex(1)->setCellValue('B1', '工号');
        $objectPHPExcel->setActiveSheetIndex(1)->setCellValue('C1', '调查总数');
        $objectPHPExcel->setActiveSheetIndex(1)->setCellValue('D1', '按键数');
        $objectPHPExcel->setActiveSheetIndex(1)->setCellValue('E1', '放弃数');
        $objectPHPExcel->setActiveSheetIndex(1)->setCellValue('F1', '非常满意');
        $objectPHPExcel->setActiveSheetIndex(1)->setCellValue('G1', '满意');
        $objectPHPExcel->setActiveSheetIndex(1)->setCellValue('H1', '不满意');
        foreach ($user as $v){
            $objectPHPExcel->getActiveSheet()->setCellValue('A'.($i) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('B'.($i) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('C'.($i) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('D'.($i) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('E'.($i) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('F'.($i) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('G'.($i) ,$v['ui_id']);
            $objectPHPExcel->getActiveSheet()->setCellValue('H'.($i) ,$v['ui_id']);
            $i = $i +1;
        }

        ob_end_clean();
        ob_start();
        header('Content-Type : application/vnd.ms-excel');

        //设置输出文件名及格式
        header('Content-Disposition:attachment;filename="座席报表统计'.'.xls"');

        //导出.xls格式的话使用Excel5,若是想导出.xlsx需要使用Excel2007
        $objWriter= \PHPExcel_IOFactory::createWriter($objectPHPExcel,'Excel5');
        $objWriter->save('php://output');
        ob_end_flush();

        //清空数据缓存
        unset($data);
    }

 

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值