laravel excel export adding additional header row

Question

here is my code:

   Excel::create($file_name, function ($excel) use ($data, $sheet_name) {
        $excel->sheet($sheet_name, function ($sheet) use ($data) {


            $data[] = ['id', 'customer', 'email', 'total', 'created_at'];
            $data[] = ['1', '2', '3', '4', '5'];
            $data[] = ['11', '2', '3', '4', '5'];
            $data[] = ['111', '2', '3', '4', '5'];
            $data[] = ['1111', '2', '3', '4', '5'];


            $sheet->fromArray($data, null, 'A1', true, true);
            });

        // Set the title
         $excel->setTitle('Our new awesome title');
        // Chain the setters
        $excel->setCreator('test')->setCompany('test');

        // Call them separately
        $excel->setDescription('A demonstration to change the file properties');

    })->export($type);

And this is my output

why it is adding 0,1,2,3,4 at the top row ?

please help thanks

Muhammad · Accepted Answer · 2018-02-12 15:56:04Z

3

instead of

 $sheet->fromArray($data, null, 'A1', true, true);

it should be this

$sheet->fromArray($data, null, 'A1', false, false);

answered Feb 12, 2018 at 15:56

Muhammad

3,2606 gold badges47 silver badges72 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

laravel excel export adding additional header row

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related