Laravel-excel: [QUESTION] Encoding problem only for CSV

[hAz4rd0uS]

• [X ] Have read and understood: https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/.github/SUPPORT.md
• [X ] Checked if your Laravel Excel version is still supported: https://docs.laravel-excel.com/3.1/getting-started/support.html#supported-versions
• [X ] Checked that your question isn't already asked before.
• [X] Filled in the entire issue template

Versions

• PHP version: 7.2.14
• Laravel version: Laravel Framework 5.6.39
• Package version: 3.1

Description

Hi, I have an encoding problem when I'm exporting a CSV file. Everything works fine in XLS and PDF formats.
I tried every single answer to this question with no luck.
Example of encoding problem : "Bibliothèque 7899" instead of "Bibliothèque 7899"

Any help would be great !

Thanks for your great plugin tho :)

[patrickbrouwers]

Have you tried setting use_bom to true in the config (https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/config/excel.php#L39) ? That's what PhpSpreadsheet suggests here: https://phpspreadsheet.readthedocs.io/en/latest/topics/reading-and-writing-to-file/#writing-utf-8-csv-files

[hAz4rd0uS]

Yes I tried this, but I fixed the issue another way. Thanks for your help.

[GlennM]

Closing as issue seems to be fixed.

[kotapeter]

@hAz4rd0uS how have you fixed?

[xlcrr]

@hAz4rd0uS why not post the solution?