Laravel-excel: Change encoding to ASCII for datev export

[Muetze42]

I would like to export the data for Datev. Datev is CSV with semicolon as separator and encoded in ASCII.

How can I change the encoding to ASCII for an export?

[patrickbrouwers]

Have you tried configuring the csv: https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/config/excel.php#L113

Also please next time fill in the issue template.

[Muetze42]

I set input_encoding to ANSI, clean the cache, but the exported file is in UTF-8

[patrickbrouwers]

I believe the way PhpSpreadsheet suggests it is by calling mb_convert_encoding yourself on the csv content. You probably have to enable BOM as well (https://github.com/Maatwebsite/Laravel-Excel/blob/3.1/config/excel.php#L38)

[Muetze42]

I just got the info that Datev supports UTF-8 since last year, but I will have a look at it. Thanks for the quick help.