phpexcel 生成csv

<?php
require_once 'vendor/autoload.php';

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Csv;

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

// 获取活动工作表
$sheet = $spreadsheet->getActiveSheet();

// 设置单元格值
$sheet->setCellValue('A1', '姓名');
$sheet->setCellValue('B1', '年龄');
$sheet->setCellValue('C1', '性别');

$sheet->setCellValue('A2', '张三');
$sheet->setCellValue('B2', 25);
$sheet->setCellValue('C2', '男');

$sheet->setCellValue('A3', '李四');
$sheet->setCellValue('B3', 30);
$sheet->setCellValue('C3', '女');

// 创建 CSV 写入器
$writer = new Csv($spreadsheet);

// 设置 CSV 文件的选项
$options = [
    'delimiter' => ',',
    'enclosure' => '"',
    'escape_char' => '\\'
];

// 保存 CSV 文件
$writer->save('data.csv', $options);
?>

$writer->save('data.csv', $options);

$options = [
    'delimiter' => ',',
];