Illegal offset type error in exporting to excel

Question

I'm trying to export an excel but when i export it, it gives me an error of Illegal offset type error. How can i make it work? Heres my code in my UsersController.

public function userExport()
{
$users = $this->users->paginate(
            $perPage = 20,
            Input::get('search'),
            Input::get('status'),
            Input::get('emp_status'),
            Input::get('level'),
            Input::get('age'),
            Input::get('gender'),
            Input::get('civil_status'),
            Input::get('role_id'),
            Input::get('birthmonth'),
            Input::get('company'),
            Input::get('branches'),
            Input::get('benefit'),
            Input::get('designation'),
            Input::get('tenure')
            // Input::get('gender')
        );
        return Excel::create('data_function',function($excel) use ($users){
            $excel->sheet('mysheet', function($sheet) use ($users){
                $sheet->fromArray($users);
            });
        })->download('xls');
    }

Because of the fromArray? Where do you think is the error? @MahdiYounesi — gwapo
– gwapo, Commented Jan 23, 2018 at 3:38
I think that You are passing paginator object $users not array. — Mahbub
– Mahbub, Commented Jan 23, 2018 at 4:44

Pravin Poudel · Accepted Answer · 2019-02-17 03:55:14Z

3

Lets do this :

this worked for me so i tried this for u please check if any change is needed for u .

        //Initialize the array which will be passed into the Excel generator

    $userarray= [];

        // Define the Excel spreadsheet headers

    $userarray[] = ['id', 'search','status','any_thing u_want'];

        // Convert each member of the returned collection into an array,

       // and append it to the payments array.

     foreach ($users as $user) {
       $userarray[] = $user->toArray();
     }

     // Generate and return the spreadsheet

    Excel::create('payments', function($excel) use ($userarray) {

    // Set the spreadsheet title, creator, and description

    $excel->setTitle('users');
    $excel->setCreator('Laravel')->setCompany('any_name, LLC');
    $excel->setDescription('info file');

    // Build the spreadsheet, passing in the payments array

    $excel->sheet('sheet1', function($sheet) use ($userarray) {
        $sheet->fromArray($userarray, null, 'A1', false, false);
    });

})->download('xlsx');
}

edited Feb 17, 2019 at 3:55

answered Jan 23, 2018 at 6:16

Pravin Poudel

1,5784 gold badges16 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

gwapo Over a year ago

whats the $invoicesArray for?

Pravin Poudel Over a year ago

sorry for that i have edited code . please check if it is any help to you ... and sorry for poor format ... i dont know why it's not showing comment in different color

gwapo Over a year ago

what should i put instead of invoicearray?

Pravin Poudel Over a year ago

check what is inside in userarray after loop

Pravin Poudel Over a year ago

return ( $userarray ); and check output it throws in network tab in developer mode ctrl+shift+i

|

Collectives™ on Stack Overflow

Illegal offset type error in exporting to excel

1 Answer 1

6 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

6 Comments

Your Answer

Sign up or log in

Post as a guest

Related