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 !');

// 导出到XLSX文件
$writer = new Xlsx($spreadsheet);
$writer->save('hello_world.xlsx');
?>

<?php
ini_set('memory_limit', '512M');
set_time_limit(300);

require 'vendor/autoload.php';

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

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

$row = 1;
foreach ($data as $item) {
    $sheet->setCellValue('A' . $row, $item['name']);
    $sheet->setCellValue('B' . $row, $item['age']);
    $row++;
}

$writer = new Xlsx($spreadsheet);
$writer->save('large_data.xlsx');
?>