$excelObj = new PHPExcel();
    $dir = '/tmp/';

    // 給表格添加數(shù)據(jù)
    $excelObj->setActiveSheetIndex(0); // 從0開(kāi)始
    $currentSheet = $excelObj->getActiveSheet(); // 獲取當(dāng)前活動(dòng)sheet
    $currentSheet->setCellValue( 'A1', 'ID' )         //給表的單元格設(shè)置數(shù)據(jù)
    ->setCellValue( 'B1', '公司全稱' )
        ->setCellValue( 'C1', '公司簡(jiǎn)稱' );

    $designObj = DB::table('design_company')->select([
        'id as ID',
        'company_name as 公司全稱',
        'company_abbreviation as 公司簡(jiǎn)稱',
    ])->get();

    $new_data = [];
    foreach ($designObj as $k=>$v){
        $arr = [];
        foreach ($v as $a=>$b){
            $arr[$a] = $b;
        }
        $new_data[] = $arr;

    }

    $j = 2;
    foreach($new_data as $val){
        $currentSheet->setCellValue('A'.$j,$val['ID'])->setCellValue('B'.$j,$val['公司全稱'])->setCellValue('C'.$j, $val['公司簡(jiǎn)稱']);
        $j++; // 每循環(huán)一次換一行寫(xiě)入數(shù)據(jù)
    }
    $sheeetWrite = \PHPExcel_IOFactory::createWriter($excelObj, 'Excel2007');
    $sheeetWrite->save($dir.'設(shè)計(jì)公司名稱.xlsx');