Set Maximum row & download multiple file excel about fast-excel HOT 6 CLOSED

Hi, you can use Laravel Collection's chunk() method to achieve this!

From the Laravel Doc:

The chunk method breaks the collection into multiple, smaller collections of a given size

So you can do something like this:

$users = User::all();
$chunks = $users->chunk(150);

foreach($chunks as $id => $chunk) {
    (new FastExcel($users))->export("file-$id.xlsx");
}

Or if you want to export in a single file with sheets, you can do something like that:

$users = User::all();
$chunks = $users->chunk(150);
$sheets = new SheetCollection($chunks);
(new FastExcel($sheets))->export("file-with-sheets.xlsx");

from fast-excel.

@rap2hpoutre thank you, i will try

from fast-excel.

Thanks @Pochwar! 👏 👏

@cybersoftmedia Did it solve your problem?

from fast-excel.

Thank you Mr @Pochwar
This function just return link ?
how about return download multiple ?
like this :

foreach($chunks as $id => $chunk) {
    return (new FastExcel($users))->download("file-$id.xlsx");
}

it possible ? i try error.

from fast-excel.

Not yet @rap2hpoutre, i need more help.

from fast-excel.

@cybersoftmedia You can only download one file. If you want to download more files, you could try to zip them first, then download the zip. This lib could help: https://github.com/Chumper/Zipper

from fast-excel.