<?php namespace App\Exports; use Maatwebsite\Excel\Concerns\FromCollection; use Maatwebsite\Excel\Concerns\WithHeadings; class ExportBankMasterData implements FromCollection,WithHeadings { /** * @return \Illuminate\Support\Collection */ public function collection() { $response= \DB::table('bank_masters')->where('is_active', 1)->get(); $n=0; $array=[]; foreach($response as $key=>$val){ $array[$n]['sr_no']=$key+1; $array[$n]['bank_name']=$val->bank_name; $array[$n]['ifsc_code']=$val->ifsc_code; $array[$n]['branch']=$val->branch; $n++; } // return $array; //return $data; return collect($array); } public function headings(): array { return [ 'Sr. No.', 'bank_name', 'ifsc_code', 'branch', ]; } }