/** * 导出Excel * 所有订单数据 */ public function exportExcelAll() { DB::setFetchMode(PDO::FETCH_ASSOC); $Orders = new Orders(); $data = $Orders->getAll(); Excel::create('order' . date("YmdHis") . rand(10, 100), function ($excel) use($data) { $excel->sheet('Sheetname', function ($sheet) use($data) { $sheet->fromArray($data); }); })->download('xls'); }