How to generate heading for columns?

Question

i generate excel using Larvel-Excel this is my function

`\Excel::create('JOBS', function($excel) {

    $excel->sheet('2015', function($sheet) {
        $jobs = \App\Job::all();
        foreach($jobs as $row){
            $data=array($row->id,$row->description,$row->vessel,$row->invoice_value);
            $sheet->fromArray(array($data),null,'A1',false,false);
        }
 });})->download('csv');

im getting out put like this correct but i want to set first row as column heading ID, Description, vessel, Value any idea??

i tried to get all the data in jobs table and generate document its working perfect but i want set heading fro every column in very first row — Prudential Developer, Jan 13 '16 at 07:26
@PrudentialDeveloper so you want the first row to be "ID | Description | Vessel | Invoice Value"? — Bogdan, Jan 13 '16 at 07:27

score 2 · Accepted Answer · answered Jan 13 '16 at 07:33

Just add the additional row with the headings before the foreach loop, the same way you add each data row:

\Excel::create('JOBS', function ($excel) {
    $excel->sheet('2015', function ($sheet) {
        $jobs = \App\Job::all();

        // Add heading row
        $data = array('ID', 'Description', 'Vessel', 'Invoice Value');
        $sheet->fromArray(array($data), null, 'A1', false, false);

        // Add data rows
        foreach ($jobs as $row) {
            $data = array($row->id, $row->description, $row->vessel, $row->invoice_value);
            $sheet->fromArray(array($data), null, 'A1', false, false);
        }
    });
})->download('csv');

can you this [link](http://stackoverflow.com/questions/34783725/how-to-ignore-gide-when-we-download-document-as-a-pdf-using-dompdf-dompdf) — Prudential Developer, Jan 14 '16 at 07:21

How to generate heading for columns?

1 Answers1