Having trouble sending a file to the downloads folder

[wranson22]

Hi Everyone!
been really enjoying using this library for a project I'm working on. I essentially have a final array that I've converted to a spreadsheet, and then I am attempting to send the xlsx file to my downloads folder. (Will figure out a way to make this happen with a button press later)
the trouble I'm running into is getting a permission denied error when trying to download the file.

code Snippet:

        $outputSpreadsheet = new PhpOffice\PhpSpreadsheet\Spreadsheet();
	$outputSpreadsheet->removeSheetByIndex(0);
	$worksheet1 = new \PhpOffice\PhpSpreadsheet\Worksheet\Worksheet($outputSpreadsheet,"Sheet1");
	$outputSpreadsheet->addSheet($worksheet1, 0);

	$worksheet1->fromArray($sheetData); 

	$writer = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($outputSpreadsheet, 'Xlsx');
	
	$writer->save('output.xlsx');

That last line ends up tracing to BaseWriter.php, which is throwing this error:
Warning: fopen(output.xlsx): Failed to open stream: Permission denied in E:...\PhpSpreadsheet\Writer\BaseWriter.php on line 117

seems like a permissions error for the user that runs on the server, but I'm unsure how to edit the level of access for the output stream.

any advice would be very appreciated!

[oleibman]

It sounds like you are trying to download the file from a browser. If so, the following code adapted from samples/Basic/01_Simple_download_Xlsx should give you an idea how to proceed:

// Redirect output to a client’s web browser (Xlsx)
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="output.xlsx"'); // name changed to match sample code above
header('Cache-Control: max-age=0');
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header('Pragma: public'); // HTTP/1.0

$writer = IOFactory::createWriter($outputSpreadsheet, 'Xlsx'); // variable name changed to match sample code
$writer->save('php://output');

[wranson22]

Thanks! I will give this a try tomorrow.
I do know I usually have trouble when trying to set headers in this workspace since my headers are already declared at the top of the page. I may have my button route me to a new page where those headers are set and it auto downloads the file.

[wranson22]

That worked! Writing to the file is the last step of this webpage, so I sent all the user selections via post to this new page, re-read the original file and then sent the file to downloads!
Even got it working with CSV so it auto detects the original file type and writes the new file in the same format.