Example on how to download an Excel file created with PhpSpreadsheet

sample.php

<?php

$streamedResponse = new StreamedResponse();
$streamedResponse->setCallback(function () {
      $spreadsheet = //create you spreadsheet here;

      $writer =  new Xlsx($spreadsheet);
      $writer->save('php://output');
});

$streamedResponse->setStatusCode(Response::HTTP_OK);
$streamedResponse->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
$streamedResponse->headers->set('Content-Disposition', 'attachment; filename="your_file.xlsx"');

return $streamedResponse->send();`

this really need to have the use statements on this, otherwise its not a solution, only further problems that need to be worked out

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;
use Symfony\Component\HttpFoundation\StreamedResponse;
use Symfony\Component\HttpFoundation\Response;

It was an excerpt from the code, but thank you for pointing it out. I hope that no one will just blindly copy and paste it.

Any way to use id "standalone" without the Symfony components?

@timo

Any way to use id "standalone" without the Symfony components?

<?php

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World !');

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

$writer = new Xlsx($spreadsheet);
$writer->save('php://output');

@timo

Any way to use id "standalone" without the Symfony components?

<?php

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setCellValue('A1', 'Hello World !');

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

$writer = new Xlsx($spreadsheet);
$writer->save('php://output');

I would add fastcgi_finish_request(); at the end: