php 保存文件为xls

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

// 创建一个Writer对象
$writer = new Xlsx($spreadsheet);

// 将文件保存到本地
$writer->save('hello_world.xlsx');
?>

// 确保目录存在并且可写
if (!is_dir('path/to/directory') || !is_writable('path/to/directory')) {
    die('Directory is not writable.');
}

// 保存文件到指定目录
$writer->save('path/to/directory/hello_world.xlsx');

composer require phpoffice/phpspreadsheet