I'm using PhpSpreadsheet to generate an Excel file in Symfony 4. My code is:
$spreadsheet = $this->generateExcel($content);
$writer = new Xlsx($spreadsheet);
$filename = "myFile.xlsx";
$writer->save($filename); // LINE I WANT TO AVOID
$response = new BinaryFileResponse($filename);
$response->headers->set('Content-Type', 'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
$response->setContentDisposition(
ResponseHeaderBag::DISPOSITION_ATTACHMENT,
$filename
);
But I don't want to save the file and then read it to return to the user. I would like to download Excel content directly. Is there a way to do It?
I've searched how to generate a stream of the content (as this answer says) but I hadn't success.
Thanks in advance and sorry about my English
As I understand you are generating the content in your code. You can stream the response in Symfony and configure PhpSpreadsheet Writer to save to 'php://output' (see here the official doc Redirect output to a client's web browser).
Here is an working example using Symfony 4.1 and Phpspreadsheet 1.3: