phpexcel 导出csv文件

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

use PHPExcel;
use PHPExcel_IOFactory;

// 创建一个新的 PHPExcel 对象
$objPHPExcel = new PHPExcel();

// 设置单元格的值
$objPHPExcel->getActiveSheet()
    ->setCellValue('A1', '姓名')
    ->setCellValue('B1', '年龄')
    ->setCellValue('C1', '邮箱');

$objPHPExcel->getActiveSheet()
    ->setCellValue('A2', '张三')
    ->setCellValue('B2', 25)
    ->setCellValue('C2', 'zhangsan@example.com');

$objPHPExcel->getActiveSheet()
    ->setCellValue('A3', '李四')
    ->setCellValue('B3', 30)
    ->setCellValue('C3', 'lisi@example.com');

// 设置单元格样式
$objPHPExcel->getActiveSheet()->getStyle('A1:C3')->getAlignment()->setHorizontal(PHPExcel_Style_Alignment::HORIZONTAL_CENTER);

// 导出为 CSV 文件
$writer = PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV');
$writer->save('data.csv');

echo 'CSV 文件已生成！';
?>

$writer->setEncoding('UTF-8');

function escape_csv($value) {
    if (strpos($value, ',') !== false || strpos($value, '"') !== false || strpos($value, "\n") !== false) {
        $value = str_replace('"', '""', $value);
        return '"' . $value . '"';
    }
    return $value;
}

// 使用示例
$name = '张三,李四';
$escapedName = escape_csv($name);
$objPHPExcel->getActiveSheet()->setCellValue('A2', $escapedName);