Level 4
@jamesfrancisramos7 Please format the code by using backticks ``` before and after the code.
Jan 22, 2018
10
Level 1
Export to excel but error "Illegal Offset type"
I'm trying to export but it there's an error saying "Illegal Offset type". My code in my UsersController goes like this, please help me experts.
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');
}
Level 1
done sir @Shawdow
Level 24
$users = $this->users->paginate(
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')
]
);
Level 1
Theres an error "Array to string conversion" @deansatch
Level 24
Not sure why you have the Input::get() but since the second arg in paginate() is an array of columns, if you remove those and just leave the names it should be valid.
eg
paginate(20, ['status', 'emp_status', etc...])
Level 1
it still says array string to conversion.
I put Input::get because i filter the table. And after i filter it i want to export it to excel
Level 24
does it tell you what line the error is on? Does paginate(20) alone work?
I see you are using fromArray(). So should you not have paginate(20)->toArray() ?
Level 1
$q->where('username', "like", "%{$search}%"); that's the line that has an error
Level 24
That line isn't in the code you posted
Level 1
its in the EloquentUser.php @deansatch
Please or to participate in this conversation.