LaravelExcel modifications to output CSV files with BOM and a helper class to abstract it

.Laravel Excel Exporter with CSV support

LaravelExcel modifications to output CSV files with BOM and a helper class to abstract it

ExcelExporter.php

<?php

namespace App\ExcelExport;

use Maatwebsite\Excel\Classes\PHPExcel;
use Maatwebsite\Excel\Excel;
use Maatwebsite\Excel\Readers\LaravelExcelReader;

class ExcelExporter
{
    public function export($name, $headers, $data, $type){
        $excel = new Excel(
            app(PHPExcel::class),
            app(LaravelExcelReader::class),
            //app(\Maatwebsite\Excel\Writers\LaravelExcelWriter::class)
            app(LaravelExcelWriterWithBetterCSVSupport::class)
        );

        $excel->create($name, function($document) use($data, $name, $headers) {
            // normal code here
        })->export($type);
    }
}

LaravelExcelWriterWithBetterCSVSupport.php

<?php

namespace App\ExcelExport;

use Maatwebsite\Excel\Writers\LaravelExcelWriter;

class LaravelExcelWriterWithBetterCSVSupport extends LaravelExcelWriter
{
    protected function _setWriter()
    {
        $writer = parent::_setWriter();
        if($this->format == 'CSV')
            $writer->setUseBOM(true);
        return $writer;
    }

}