range

If there were you, the world would be just right

Trapecho

PHPExcel导出

作者：admin 发布时间：October 11, 2019 分类：PHP No Comments

php 导出

下载PHPExcel

composer require phpoffice/phpexcel

导出方法

function exportExcel($field, $list, $title='文件')
{
    $objPHPExcel = new \PHPExcel();
    foreach ($list as $key => $value) {
        foreach ($field as $k => $v) {
            if ($key == 0) {
                $objPHPExcel->getActiveSheet()->setCellValue($k . '1', $v[1]);
            }
            $i = $key + 2; //表格是从2开始的
            $objPHPExcel->getActiveSheet()->setCellValue($k . $i, $value[$v[0]]);
        }

    }
    header("Pragma: public");
    header("Expires: 0");
    header("Cache-Control:must-revalidate, post-check=0, pre-check=0");
    header("Content-Type:application/force-download");
    header("Content-Type:application/vnd.ms-execl");
    header("Content-Type:application/octet-stream");
    header("Content-Type:application/download");;
    header('Content-Disposition:attachment;filename='.$title.'.xlsx');
    header("Content-Transfer-Encoding:binary");
    $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
    $objWriter->save('php://output');
}