php页面导出excel

<?php
require 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

// 创建一个新的Spreadsheet对象
$spreadsheet = new Spreadsheet();

// 获取当前活动的工作表
$sheet = $spreadsheet->getActiveSheet();

// 设置单元格的值
$sheet->setCellValue('A1', 'Hello World !');
$sheet->setCellValue('A2', '123');
$sheet->setCellValue('B2', '456');

// 设置单元格样式
$styleArray = [
    'font' => [
        'bold' => true,
    ],
];
$sheet->getStyle('A1')->applyFromArray($styleArray);

// 写入文件
$writer = new Xlsx($spreadsheet);
$filename = 'example.xlsx';
$writer->save($filename);

// 设置HTTP头，提示浏览器下载文件
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="' . $filename . '"');
header('Cache-Control: max-age=0');

// 读取文件内容并输出
$writer->save('php://output');
exit();
?>