$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
改成下方即可
$objWriter = IOFactory::createWriter($objPHPExcel, 'Excel2007');
//$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5'); php7之前
$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
// 从浏览器直接输出$filename
header('Content-Type:application/csv;charset=UTF-8');
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-excel;");
header("Content-Type:application/octet-stream");
header("Content-Type:application/download");
header('Content-Disposition: attachment;filename="'.$name.'.xls"');
header("Content-Transfer-Encoding:binary");
$objWriter->save('php://output');