mardi 5 juin 2018

How to remove array keys while exporting using Mattwebsite excel?

I am exporting data to excel using Maatwebsite excel. I am using laravel framework. My array is looking like this:-

Array
(
[0] => Array
    (
        [0] => Name
        [1] => Salary
        [2] => Age
        [3] => Gender
    )

[1] => Array
    (
        [0] => Kunal
        [1] => 12000
        [2] => 15
        [3] => M
    )

[2] => Array
    (
        [0] => Kunal
        [1] => 16000
        [2] => 17
        [3] => m
    )
)
that is saved in this variable $detailArray

My exporting function is look like this:-

Excel::create("Test", function($excel) use($detailArray) {
        $excel->sheet('Sheet', function($sheet) use($detailArray) {
            $sheet->fromArray($detailArray, null, 'A1', true);
        });
    })->export('xls');

Now when i export excel its look like this:- enter image description here

Now i want to remove the 0,1,2,3 these keys as showing in image. Please help me how to resolve this issue.Thanks in advance.



via Chebli Mohamed

Aucun commentaire:

Enregistrer un commentaire