php导出表格数据

0.基本配置

百度云链接
密码: m7ch
将配置文件放置在vendor目录下

1.创建数据

public function create_export0($list,$val){        $list =[]; //数据        $val=‘’;  //类型        $this->createReport($list,$val);}

2.创建表格

public function createReport($list,$val)    {    //标题名称        $expCellName = [            ['0', '用户名称', 'name'],  //name为$list的键名            ['1', '参与时间', 'addtime'],           ......        ];        $count =count($list);   //总条数        if ($val=='1'){            $str ='本次统计共：'.$count.' 条 '.'，统计范围：1';        }elseif ($val=='2'){            $str ='本次统计共：'.$count.' 条 '.'，统计范围：2';        }else{            $str ='本次统计共：'.$count.' 条 '.'统计范围：3';        }        $this->excel3($expCellName, $list, $str);}

3.导出表格

        $xlsTitle = iconv('utf-8', 'gb2312', '');        $fileName = date('数据统计_Ymd');// 文件名称        $cellNum = count($expCellName);        $dataNum = count($expTableData);        Vendor("PHPExcel.PHPExcel");        $objPHPExcel = new \PHPExcel();        $cellName = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I','J');        $objPHPExcel->getActiveSheet(0)->mergeCells('A1:' . $cellName[$cellNum - 1] . '1');//合并单元格        $objPHPExcel->setActiveSheetIndex(0)->setCellValue('A1', $str);        for ($i = 0; $i < $cellNum; $i++) {            $objPHPExcel->setActiveSheetIndex(0)->setCellValue($cellName[$i] . '2', $expCellName[$i][1]);        }        if ($dataNum > 0) {            //逻辑区            for ($i = 0; $i < $dataNum; $i++) {                for ($j = 0; $j < $cellNum; $j++) {                    $objPHPExcel->getActiveSheet(0)->setCellValue($cellName[$j] . ($i + 3), $expTableData[$i][$expCellName[$j][2]]);                }            }        }        ob_end_clean();//清除缓冲区,避免乱码        header('pragma:public');        header('Content-type:application/vnd.ms-excel;charset=utf-8;name="' . $xlsTitle . '.xls"');        header("Content-Disposition:attachment;filename=$fileName.xls");        //attachment新窗口打印inline本窗口打印        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');        $objWriter->save('php://output');        exit;    }