PHP导出excel

①通过composer下载,命令行中运行如下命令

composer require phpoffice/phpexcel

②定义一个静态方法

public static function exportExcel($tableHeader,$tableContent,$tableFileName)    {        // require_once '../vendor/phpoffice/phpexcel/Classes/PHPExcel.php';        //通过composer安装的包,可以直接在代码或控制器中实例化        $objPHPExcel = new \PHPExcel();        //生成表格的列名,A~ZZ(最大702列)        $arr         = range('A','Z');        $temp        = $arr;        foreach ($temp as $shi) {            foreach ($temp as $ge) {                $arr[] = $shi . $ge;            }        }        unset($temp);        //设置表头        foreach ($tableHeader as $key => $value) {            $objPHPExcel->setActiveSheetIndex(0)                ->setCellValue($arr[$key].'1',(string)$value);        }        //设置表内容        foreach ($tableContent as $key => $value) {            $i = 0;            foreach ($value as $value1) {                $objPHPExcel->setActiveSheetIndex(0)                    ->setCellValue($arr[$i].($key+2),(string)$value1);                $i++;            }        }        // $objPHPExcel->getActiveSheet()->setTitle(date('YmdHis').'商品表');        // Set active sheet index to the first sheet, so Excel opens this as the first sheet        $objPHPExcel->setActiveSheetIndex(0);        // Redirect output to a client’s web browser (Excel5)        header('Content-Type: application/vnd.ms-excel');        header('Content-Disposition: attachment;filename="'.$tableFileName.'.xls"');        header('Cache-Control: max-age=0');        // If you're serving to IE 9, then the following may be needed        header('Cache-Control: max-age=1');        // If you're serving to IE over SSL, then the following may be needed        header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past        header('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT'); // always modified        header('Cache-Control: cache, must-revalidate'); // HTTP/1.1        header('Pragma: public'); // HTTP/1.0        $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');        $objWriter->save('php://output');    }