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">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
< 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>
$dir=dirname(_FILE_); The first line is wrong. The magic constant is __FILE__, not _FILE_.