PHPSpreadsheet download xlsx in browser

Question

I want download my generate Xlsx file on my browser but when I execute this code, the request is launched without error but nothing happens

   header("Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
    header('Content-Disposition: attachment; filename='.basename($pathfile).'');
    header('Cache-Control: max-age=0');


    File::setUseUploadTempDirectory(true);

    $objWriter = IOFactory::createWriter($objWorkBookExcel, 'Xlsx');

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

header

When I use this :

$objWriter->save($pathfile);

My file is generated on my server

Simone Rossaini · Answer 1 · 2020-06-09T13:15:28.780

0

I recommend using PHPspreedsheet the evolution of PHPOffice!

Try that:

$objWriter = io_factory::createWriter($objPHPExcel, 'Xlsx');


header("Pragma: public");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
header("Content-Type: application/force-download");
header("Content-Type: application/octet-stream");
header("Content-Type: application/download");;
header("Content-Disposition: attachment;filename=nameoffile.xlsx");
header("Content-Transfer-Encoding: binary ");

ob_end_clean();
ob_start();
$objWriter->save('php://output');
exit;

If you use PHPExcel:

$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="' . $filename . '.xlsx"');
$objWriter->save('php://output');
die();

edited Jun 09 '20 at 13:15

answered Jun 09 '20 at 13:09

Simone Rossaini

8,115
1
13
34

[2020-06-09 15:12:02] default.WARNING: Exception 'ErrorException' with message 'ZipArchive::close(): Failure to create temporary file: No such file or directory' – Dylan Antonio Jun 09 '20 at 13:12
have you change my filename? – Simone Rossaini Jun 09 '20 at 13:14
see here [link](https://stackoverflow.com/questions/50470370/phpspreadsheet-permissions-ziparchiveclose-failure-to-create-temporary-f) – Simone Rossaini Jun 09 '20 at 13:25
I add : File::setUseUploadTempDirectory(true); the error is gone, I have content but the file does not download – Dylan Antonio Jun 09 '20 at 13:31
without that control? – Simone Rossaini Jun 09 '20 at 13:41
I don't understand – Dylan Antonio Jun 09 '20 at 14:27

score 0 · Answer 2 · answered Jun 09 '20 at 13:34

Now I'm here

  $objWriter = IOFactory::createWriter($objWorkBookExcel, 'Xlsx');

    header("Pragma: public");
    header("Expires: 0");
    header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
    header("Content-Type: application/force-download");
    header("Content-Type: application/octet-stream");
    header("Content-Type: application/download");;
    header("Content-Disposition: attachment;filename='nameoffile.xlsx'");
    header("Content-Transfer-Encoding: binary ");

    ob_end_clean();
    ob_start();
    File::setUseUploadTempDirectory(true);
    $objWriter->save('php://output');      
    exit;

Header

but no downloaded file

PHPSpreadsheet download xlsx in browser

2 Answers2