php生成excel完整实例代码

composer require phpoffice/phpspreadsheet

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

// 合并单元格
$sheet->mergeCells('C1:D2');

// 设置单元格样式
$styleArray = [
    'font' => [
        'bold' => true,
    ],
    'alignment' => [
        'horizontal' => \PhpOffice\PhpSpreadsheet\Style\Alignment::HORIZONTAL_CENTER,
    ],
];

$sheet->getStyle('C1')->applyFromArray($styleArray);

// 添加数据表
$data = [
    ['Name', 'Age', 'Country'],
    ['John', 25, 'USA'],
    ['Jane', 22, 'UK'],
    ['Chris', 30, 'Australia'],
];

$sheet->fromArray($data, null, 'A4');

// 创建写入器对象
$writer = new Xlsx($spreadsheet);

// 写入文件
$writer->save('hello_world.xlsx');

echo 'Excel file created successfully.';
?>