Encoding values of cells in UTF8

[AmaurySchmitt]

Hi everyone,

I have been on this encoding problem for over a month. I would like to encode each value of my cells in ANSI format because it is the only one that supports French with Excel. However, I saw from my numerous researches that the 'input_encoding' is not compatible in ANSI, unfortunately French does not work 100% with UTF-8 unlike ANSI

The solution is therefore to encode my data line by line for the export. Thank you for your help ! @patrickbrouwers

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\WithMapping;
use Yajra\DataTables\Exports\DataTablesCollectionExport;
use Maatwebsite\Excel\Concerns\WithCustomCsvSettings;


class ListStudentsExport extends DataTablesCollectionExport implements WithMapping, WithCustomCsvSettings
{
    public function headings(): array
    {
        return [
            'id',
            'numstudent',
            'lastname',
            'firstname',
        ];
    }

    public function map($row): array
    {
        return [
            $row['id'],
            $row['numStudent'],
            $row['lastName'],
            $row['firstName'],
        ];
    }

    public function getCsvSettings(): array
    {
        return [
            'delimiter' => ';',
            'enclosure' => '',
            'line_ending' => PHP_EOL,
            'use_bom' => true,
        ];
    }
}

An example of error :
Data in database : &é"'àè-°*:+=?çëê Data when exporting in csv : é"'àè-°*:+=?çëê

[patrickbrouwers]

Sorry I don't have a clue. Perhaps Stackoverlow can be of help.