Level 63
The page on which the user is on ... do you mean the Excel sheet ?
Oct 4, 2022
6
Level 1
export to excel with laravel excel
hello friends, I am implementing excel download of a table with paging, how is it possible to export only the records that are shown on the page that the user is on. Thank you
Level 1
@vincent15000 no, I mean this, that the excel is downloaded according to the page that the end user is currently reviewing, that is, if it is on page 1, only those on page 1 are downloaded and so on
1 like
Level 63
@eLekun Oh you mean the page of the pagination.
You have to send a request with the page number (pagination page) and retrieve that page in a controller to export the collection to Excel.
Level 1
@vincent15000 Yes, exactly, but I don't quite understand how the query would be to export the records of that page.
1 like
Level 1
I have solved it in the following way in the controller, thanks!
$users = User::paginate(5, ['*'], 'page', $pageNumber);
1 like
Level 63
@eLekun My answer didn't help you ?
Please or to participate in this conversation.