douyue4334 2016-06-22 04:38
浏览 268
已采纳

在Laravel中将数据导出到Excel

I want to make export data into excel in my project, i have made it, but after I check the results, the results doesnt like what I want. here I would like to make a result there is a title table.

This code my controller:

public function getExport(){
        Excel::create('Export data', function($excel) {

        $excel->sheet('Sheet 1', function($sheet) {

            $products=DB::table('log_patrols')
            ->join("cms_companies","cms_companies.id","=","log_patrols.id_cms_companies")
            ->join("securities","securities.id","=","log_patrols.id_securities")
            ->select("log_patrols.*","cms_companies.name as nama_companies","securities.name as nama_security")
            ->get();
                foreach($products as $product) {
                 $data[] = array(
                    $product->date_start,
                    $product->date_end,
                    $product->condition_status,
                    $product->nama_security,
                    $product->nama_companies,
                );
            }
            $sheet->fromArray($data);
        });
    })->export('xls');
    }

this my problem result : result

and it should be :

should

my problem is how to change the number into text what i want in the header table.

what improvements do i have to make to the code to achieve my goal?

NB : i use maatwebsite/excel

  • 写回答

1条回答 默认 最新

  • dounabi6295 2016-06-22 05:23
    关注

    From the official docs:

    By default the export will use the keys of your array (or model attribute names) as first row (header column). To change this behaviour you can edit the default config setting (excel::export.generate_heading_by_indices) or pass false as 5th parameter:

    Change:

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

    how to change the number into text what i want in the header table.

    Then you can define your own heading and prepend it to the first row of the sheet.

    $headings = array('date start', 'date end', 'status condition', 'security', 'company');
    
    $sheet->prependRow(1, $headings);
    

    That should make it work.

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?