Проблема: < /p>
Код: Выделить всё
save('php://output'); is not downloading the xlsx file.
php версия:
[*] localhost: 8.1.6
Live Server: 8.0.28
class = "lang-php prettyprint-override">
Код: Выделить всё
require('PhpSpreadsheet/vendor/autoload.php');
use PhpOffice\PhpSpreadsheet\IOFactory;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Style\Alignment;
use PhpOffice\PhpSpreadsheet\Style\Fill;
use PhpOffice\PhpSpreadsheet\Style\Border;
// WORKSHEET 1
$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();
$sheet->setTitle('STACKOVERFLOW');
$spreadsheet->getDefaultStyle()->getFont()->setName('Calibri')->setSize(9);
$sheet->getColumnDimension('A')->setWidth(40);
$sheet->getColumnDimension('B')->setWidth(40);
$sheet->getColumnDimension('C')->setWidth(20);
$sheet->getColumnDimension('D')->setWidth(20);
$sheet->getColumnDimension('E')->setWidth(20);
$sheet->getColumnDimension('F')->setWidth(20);
$sheet->getColumnDimension('G')->setWidth(40);
$sheet->setCellValue('A1', 'UNREAL');
$writer = IOFactory::createWriter($spreadsheet, 'Xlsx');
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment; filename="spreadsheet.xlsx"');
header('Cache-Control: max-age=0');
$writer->save('php://output');
to html и filename = "spredsheet.xlsx" to fillsheet.html
Подробнее здесь: https://stackoverflow.com/questions/770 ... phpspreads