CSV export for Excel

csv-download.php

<?php

use League\Csv\Writer;
use League\Csv\AbstractCsv;

$csv = Writer::createFromFileObject(new \SplTempFileObject());
$csv->setDelimiter(';');
$csv->setOutputBOM(AbstractCsv::BOM_UTF8); // compatibility with Excel

$csv->insertOne(['1', 'é', 'à']);

$csv->output('my-file.csv');
exit();

csv-temp-file.php

<?php

use League\Csv\Writer;
use League\Csv\AbstractCsv;

$tmpFile = storage_path('temp/commandes-' . uniqid() . '.csv', 'w+');

file_put_contents($tmpFile, chr(239) . chr(187) . chr(191));

$products = $this->produits->map(function ($item) {
    return [
        'produit'         => $item->nom,
    ];
});

$csv = Writer::createFromPath($tmpFile, 'a');
$csv->setDelimiter(';');
$csv->setOutputBOM(Writer::BOM_UTF8); // compatibility with Excel

$csv->insertOne([
    'Produit',

]);
$csv->insertAll($products);

Mail::send('commande-admin', ['commande' => $this], function ($message) use ($tmpFile) {
    $message->to('test@example.com');
    $message->attach($tmpFile, ['as' => 'detail_commande_' . date('Y-m-d-His') . '.csv']);
});

unlink($tmpFile);