Call to a member function toArray() on array(Export table to excel)

I want to export the table but not all fields have to be exported. sorry my english is not very good...

       function excel
 public function excel()
     {
     $rekanan_internal = rekanan_internal::all();
     $selectsArray = DB::table('rekanan_internal')->select('nama','description','pic','contact')       
     ->get()->toArray();
    Excel::create('rekanan_internal', function($excel) use($rekanan_internal){
        $excel->sheet('sheet1',function($sheet) use($selectsArray){
            $sheet->fromArray($rekanan_internal);
        });
    })->download('xlsx');
}

getting error : Call to a member function toArray() on array

Talinon

8 years ago

Level 51

Maybe try this instead?


  Excel::create('rekanan_internal', function($excel) use($selectsArray){
        $excel->sheet('sheet1',function($sheet) use($selectsArray){
            $sheet->fromArray($selectsArray);
        });

robrogers3

8 years ago

Level 37

do this: $rekanan_internal = rekanan_internal::get(['nama','description','pic','contact'])

that will only return the columns you want to export.

Please or to participate in this conversation.