Laravel-excel: Chunking Export

[tomhoad]

Is it possible to chunk export (with PDF::loadView)?

I have about 70,000 rows to export and I am hitting a timeout.

[mikevrind]

I'm wondering the same thing. When I try to export a dataset which contains 100K+ records I have timeout problems. But when I try to chunk the results, I only have the first chunk in de export:

$getData->contacts()->chunk(5000, function($chunkContacts) use ($row, $sheet)
    {

        foreach( $chunkContacts as $contact )
        {

            # Add contact to file
            $sheet->row( $row, [ $contact->email,
                                 $contact->firstname,
                                 $contact->lastname,
            ] );

            $row++;

        }
    });

It appears that the chunk method generated some kind of output which causes the Excel file to be created immediately.

[RossTsachev]

I have a similar issue, would appreciate if someone has figured it out.

[denizaygun]

Same issue here, can't export 20,000 rows and it takes a long time.

[muhamed-didovic]

Any new info on this?

[tomswinkels]

Same problem, is there any update of this problem? When i export 33.000 rows with 10 colums i had no problem. When i export the 33.000 rows with the 11the colum than i have the problem.

[JefMari]

Is there other solution for exporting thousands of row that is fast enough?

[fpena]

An example of how to do this:

Excel::create('ExcelFile', function($excel) {
    $excel->sheet('Sheet1', function($sheet) {
        ExampleModel::chunk(500, function($modelInstance) use($sheet) {

            $modelAsArray = $modelInstance->toArray();
            $sheet->appendRow($modelAsArray);
        });
    });
})->export('xls');

[mikevrind]

Interesting solution to just 'invert' the logic! I'm curious if it helps other people who experienced the same problem.

[AlphaGeek509]

How is this task performed with v3.0?

[mikevrind]

https://laravel-excel.maatwebsite.nl/docs/3.0/export/from-query