PHPExcel output file is empty

Question

I downloaded PHPExcel library but could not use it. I am using one of the examples in the Library but it downloads an empty excel file. Here is my code.

require_once 'PHPExcel.php';
$objPHPExcel = new PHPExcel();
$objPHPExcel->getProperties()->setTitle("document");
$objPHPExcel->setActiveSheetIndex(0)
        ->setCellValue('A1', 'Hello')
        ->setCellValue('B1', 'world!');
$objPHPExcel->getActiveSheet()->setTitle('Simple');
$objPHPExcel->setActiveSheetIndex(0);
header("Content-Type: application/vnd.ms-excel");
header('Content-Disposition: attachment;filename="deneme.xls"');

Am i forgetting something here? It is simple but downloaded excel file is empty. Does anyone have an idea?

EDIT: Solved: I have to add these lines:

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

If you're using a content type of application/vnd.ms-excel and a file extension of .xls, you should be using the Excel5 writer; not Excel2007 — Mark Baker
– Mark Baker, Commented Sep 21, 2012 at 14:49

ronalchn · Accepted Answer · 2012-09-21 13:16:28Z

3

Add this:

header('Cache-Control: max-age=0');
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->save('php://output');
die();

edited Sep 21, 2012 at 13:16

ronalchn

12.4k10 gold badges53 silver badges61 bronze badges

answered Sep 21, 2012 at 11:35

Frank Linno WELL

272 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Mark Baker · Accepted Answer · 2012-09-21 11:35:00Z

1

You're forgetting to instantiate a writer and then save

answered Sep 21, 2012 at 11:35

Mark Baker

213k34 gold badges354 silver badges390 bronze badges

Collectives™ on Stack Overflow

PHPExcel output file is empty

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related