Excel cannot be output in the browser.

This is my code

<?php

$dir=dirname(_FILE_);

require $dir."/PHPExcel/PHPExcel.php" ;

$objPHPExcel=new PHPExcel();

$objSheet=$objPHPExcel->getActiveSheet();

$objSheet->setTitle("demo") ;

//$objSheet->setCellValue("A1","Coco")->setCellValue("b1","Egg");

$array=array(

array("Name","Age"),

array("Dake","58")

);

$objSheet ->fromArray($array);

$objWriter=PHPExcel_IOFactory::createWriter($objPHPExcel,"Excel5");

$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);

header('Content-Type: application/vnd.ms-excel');

header('Content-Disposition: attachment;filename="ch3.xls"') ;

header('Cache-Control: max-age=0');

$objWriter->save("php://output");

?> But the generated xls file does exactly this:

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http:// www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<head>

< title>Untitled Document</title>

</head>

<body>��ࡱ�;��

��Oh�� '��0�@Hh��

��Untitled SpreadsheetUnknown CreatorUnknown Creator@��@�@��@� �

��B�=�%r8X"1��Calibri�� 8��3f��ff��f��̙��̙3f�3��fff��3f3�f333�3�3f33�333�demo��g��Y

Tt^��'Y�S

�

��* ��&ffffff�?'ffffff�?(�?)�?�"dXX333333�?333333�?U}$ }$ �

�

M@>�@d��dgg��

��՜.�� ,��0�HPX`hp

x��

WorksheetFeuilles de calculRoot Entry�� F��@��@��SummaryInformation(�� F�Workbook�� F�DocumentSummaryInformation8�� F��

</body>

</html>

phpcn_u130742659 days ago1721