php生成excel文件

实例

 if($type == 'excel2003')
{  
 header('Content-Type: application/vnd.ms-excel');  
 header("Content-Disposition: attachment;filename='{$fileName}'");  
 header('Cache-Control: max-age=0');  
 $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');  
 $objWriter->save('php://output');  
}
else{  
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');    
header("Content-Disposition: attachment;filename='{$fileName}'");    
header('Cache-Control: max-age=0');    
$objWriter = \PHPExcel_IOFactory:: createWriter($objPHPExcel, 'Excel2007');    
$objWriter->save( 'php://output');    
  
  }