解决方案:
1.PHPExcel将数据转换为excel,直接返回转换好数据流,然后通过write()输出到浏览器,这个需要研究PHPExcel是如何处理的,比较麻烦。
2.思考了一个简单的处理方法,save保存个临时文件,读取文件数据流,通过write()输出到浏览器,然后删除临时文件
$filename = $filename ? $filename . '.xls' : 'weadoc_' . date('YmdHis') . '.xls';
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save($filename);
$response = response();
//设置header头
$response->getSwooleResponse()->header('Content-Type', 'application/vnd.ms-excel');
$response->getSwooleResponse()->header('Content-Disposition',
'attachment;filename=' . $filename);
$response->getSwooleResponse()->header('Cache-Control', 'max-age=0');
//$response->getSwooleResponse()->sendfile($filename);
//打开文件
$handler = fopen($filename, 'r+b');
$file_size = filesize($filename);
$data = fread($handler,$file_size);
fclose($handler);
$response->getSwooleResponse()->write($data);
// 删除临时文件
unlink($filename);