Laravel-admin: 导出csv文件用excel打开乱码怎么解决,用记事本另存ansi编码之后正常。

Created on 20 May 2017  ·  1Comment  ·  Source: z-song/laravel-admin

导出csv文件用excel打开乱码怎么解决,用记事本另存ansi编码之后正常,这个可以在代码里面改写直接转换吗?

Most helpful comment

於CsvExporter.php

  public function export()
    {
        .....
        $headers = [
            'Content-Encoding'    => 'UTF-8',
            'Content-Type'        => 'text/csv;charset=UTF-8',
            'Content-Disposition' => "attachment; filename=\"$filename\"",
        ];
        echo "\xEF\xBB\xBF";    //<====== 多加這一段
        response(rtrim($output, "\n"), 200, $headers)->send();

        exit;
    }

>All comments

於CsvExporter.php

  public function export()
    {
        .....
        $headers = [
            'Content-Encoding'    => 'UTF-8',
            'Content-Type'        => 'text/csv;charset=UTF-8',
            'Content-Disposition' => "attachment; filename=\"$filename\"",
        ];
        echo "\xEF\xBB\xBF";    //<====== 多加這一段
        response(rtrim($output, "\n"), 200, $headers)->send();

        exit;
    }
Was this page helpful?
0 / 5 - 0 ratings

Related issues

chenyongmin picture chenyongmin  ·  3Comments

abufalbo picture abufalbo  ·  3Comments

antranapp picture antranapp  ·  3Comments

amun1303 picture amun1303  ·  3Comments

vlongen picture vlongen  ·  3Comments