PHP导出csv

发表于2024-01-16更新于2024-01-16

PHP生成csv文件

  • 换行可以用\n

    1
    echo $v."\n";

  • 输出字符串,在内容输出后加一个字符即可输出字符串

    1
    echo '游戏包'.',';

    代码示例

    1
    2
    3
    4
    5
    6
    7
    8
    9
    10
    11
    12
    13
    14
    15
    16
    17
    18
    19
    20
    21
    22
    23
    24
    25
    26
    27
    28
    function setExportHeader($fileName , $type = 'txt')
    {
        if($type == 'excle'){
            header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
        } else  {
            header('Content-Type: application/octet-stream');
        }

        header('Content-Disposition: attachment;filename=' . $fileName);
        header('Cache-Control: max-age=0');
        header('Cache-Control: max-age=1');
        header ('Expires: Mon, 26 Jul 1997 05:00:00 GMT');
        header ('Last-Modified: '.gmdate('D, d M Y H:i:s').' GMT');
        header ('Cache-Control: cache, must-revalidate');
        header ('Pragma: public');
    }

    setExportHeader('file.csv');

    echo '第一列'.',';
    echo '第二列'.',';

    foreach($arr as $k=>$v)
    {
        echo $v['line1'].",";
        echo $v['line2']."\n";
    }