PHP headers not working on server but works on local server?

Question

header("Content-type: application/octet-stream"); 
header("Content-Disposition: attachment; filename=filename.xls");
header("Pragma: no-cache");
header("Expires: 0");

On my local system above code work properly but on server its not work.

maybe you should change content type? try this header('Content-Type: application/vnd.ms-excel'); — sanj, Mar 19 '13 at 10:59
Check this [link][1] if it provides any clue related to your question [1]: http://stackoverflow.com/questions/11072042/headerlocation-redirect-works-on-localhost-but-not-on-remote-server — Anish, Mar 19 '13 at 11:00

score 0 · Answer 1 · answered Mar 19 '13 at 10:58

I don't know yet if it will help you, but if you wan't, you can generalize octet-stream output for some extension, directly in VirtualHost config.

For that, use AddType application/octet-stream .xlsx .xls

And all url to Excel files would be downloaded.

score 0 · Answer 2 · answered Oct 17 '13 at 05:44

write ob_clean() just before the last line below , i was having same problem got resolved by this

header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="temlik.xls"');
header('Cache-Control: max-age=0');

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
ob_clean();
$objWriter->save('php://output');

PHP headers not working on server but works on local server?

2 Answers2