How can I export laravel pagination data to Excel ? about fast-excel

[rap2hpoutre]

Hi, thank you!

I'm not sure I understand your need. Do you want to:

1. export one sheet for each page (let's say: "sheet 1 -> users from 1 to 50", "sheet 2 -> users from 51 to 100", etc.)?
2. or export only the users returned by the paginate method?
3. or something else (in this case could you please elaborate)?

Thanks for answering , but I mean that how I can use pagination data result for exporting, as you know , Laravel pagination merhod every time return object includes "data" key and I couldn't access that ,
I wanna how I can get "data" as a collection for using in new FastExcel($data) ?

[rap2hpoutre]

Sorry for the delay!

I just tested and I think I understood the problem: you need to convert the array to a collection, just like this:

$items = User::paginate(10);
$data = collect($items->toArray()['data']); // <- collect the data here.
return (new FastExcel($data))->download('file.xlsx');

I hope it's not too late for you! Let me know if you have any more question!

[rap2hpoutre]

@webcoweb Did it fix your issue?