用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', '12345');

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

// 保存文件到指定目录
$writer = new Xlsx($spreadsheet);
$filePath = '/path/to/your/directory/example.xlsx';
$writer->save($filePath);

echo "Excel file has been created successfully at: " . $filePath;
?>