export excel with custom headers

[roxozur]

i have this piece of code

memberController.php

  $serialiser = new Serialiser();
  $excel = Exporter::make('Excel');
        $excel->loadQuery($query);
       $excel->setSerialiser($serialiser);
        return $excel->stream('Members.xlsx');

and i made a class inside App\CustomClass\

use namespace App\CustomClass;
classs Serialiser implements SerialserInterface
{
 public function getData($data)
    {
        $row = [];

        $row[] = $data->field1;
        $row[] = $data->field2;
        $row[] = $data->field3;

        return $row;
    }

    public function getHeaderRow()
    {
        return [
            'Field 1',
           'Field 2',
           'Field 3',
        ];
    }

}

but this does not seem to work

[abosaqr]

You could just extend the basic serialiser, and override what you need

namespace App\Serialisers; use Illuminate\Database\Eloquent\Model; // use Cyberduck\LaravelExcel\Contract\SerialiserInterface; use Cyberduck\LaravelExcel\Serialiser\BasicSerialiser; class CustomSerialiser extends BasicSerialiser { public function getHeaderRow() { return [ 'header field 1', 'header field 2', 'header field 3', ]; } }