php导出excel类

<?php
header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
header('Content-Disposition: attachment;filename="data.xlsx"');
header('Cache-Control: max-age=0');

require_once 'vendor/autoload.php';

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

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

// 设置表头
$sheet->setCellValue('A1', 'ID');
$sheet->setCellValue('B1', 'Name');
$sheet->setCellValue('C1', 'Email');

// 填充数据
$data = [
    ['1', 'John Doe', 'john@example.com'],
    ['2', 'Jane Smith', 'jane@example.com'],
    // 更多数据...
];

foreach ($data as $row => $rowData) {
    foreach ($rowData as $col => $cellData) {
        $sheet->setCellValueByColumnAndRow($col + 1, $row + 2, $cellData);
    }
}

// 创建一个写入器并保存文件
$writer = new Xlsx($spreadsheet);
$writer->save('php://output');
?>

$spreadsheet->getDefaultStyle()->getFont()->setName('Arial Unicode MS');