PhpSpreadsheet return file instead of saving it

php phpspreadsheet
Brambor picture Brambor · May 13, 2018 · Viewed 12k times · Source

I have generated xmlx file and I am able to save it and provide it for the user via:

$writer->save('hello world.xlsx');
header('Location: hello world.xlsx');

However, then the file remains on the hard drive. I need to get rid of it as it is a security threat.

I tried unlinking the file

unlink('hello world.xlsx');

but that deletes the file too early so the user doesn't have access to it. If it can work with unlink then I need to be sure the file will be deleted (so proper using of die(); and such)

EDIT: It is not only for security reasons anymore. The provider doesn't allow saving files so it is the only way to go.

Answer

Artyom Sokolov picture Artyom Sokolov · May 13, 2018

Use php://output

header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment; filename="file.xls"');
$writer->save("php://output");

Related questions

Setting width of spreadsheet cell using PHPExcel

I'm trying to set the width of a cell in an Excel document generated with PHPExcel with: $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setWidth('10'); $objPHPExcel->getActiveSheet()->getColumnDimensionByColumn('C')->setAutoSize(false); …

Read More
Merge Cell values with PHPExcel - PHP

I have a simple table like: - id - first_name - last_name - email - phone I'm using PHPExcel to export my data in XLS format $rowNumber = 1; while ($row = mysql_fetch_row($result)) { $col = 'A'; foreach($row as $…

Read More
Composer require phpoffice/phpspreadsheet doesn't work

I want to write a Script using the package Phpspreadsheet. I am not experience in php. I am trying to add the reference to my script through sudo composer require phpoffice/phpspreadsheet. But it doesn't work. I am getting the …

Read More