Laravel Excel 3.1 export large data

Question

I need to export over 100K records to Excel from database using Maatwebsite Laravel excel 3.1 plugin, the problem is that I get data as an array.

$data = $this->client->getData("sc/asistencia-social/informe",$request->all());

 return (new ExcelExport($data))->store('myFile.xlsx'); //using FromQuery

My ExcelExport Class :

<?php

namespace App\Exports;

use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\Exportable;
use Illuminate\Contracts\Queue\ShouldQueue;
use Illuminate\Queue\SerializesModels;

class ExcelExport implements FromQuery
{
 use Exportable, SerializesModels;
 private $data;

public function __construct($data)
{   
   $this->data = $data;     //Inject data 
}

public function query()
{   
   return $this->data;  
}
}

Actually, I get a "Call to a member function chunk() on array" error. I even tried to convert it into a collection with no success. Is there any possible solution to this.

Tharaka Dilshan · Accepted Answer · 2019-05-02 15:12:27Z

2

You have created your export class as FromQuery export class. instead create a FromArray export class.

Note the Implement interface and the function name

class ExcelExport implements FromArray // this was FromQuery before
{
    use Exportable, SerializesModels;

    private $data;

    public function __construct($data)
    {   
        $this->data = $data;     //Inject data 
    }

    public function array(): array // this was query() before
    {   
        return $this->data;  
    }
}

edited May 2, 2019 at 15:12

answered May 2, 2019 at 14:52

Tharaka Dilshan

4,4993 gold badges17 silver badges29 bronze badges

Sign up to request clarification or add additional context in comments.

6 Comments

Rodrigo Cabrera Over a year ago

I testes it and getting a "Declaration of App\Exports\ExcelExport::array() must be compatible with Maatwebsite\Excel\Concerns\FromArray::array(): array"

Tharaka Dilshan Over a year ago

I think it's because of missing return type of array() function, Updated the answer

Rodrigo Cabrera Over a year ago

It's still running, it's taking more than 4 minutes to export aprox 30k records, I read the FromQuery leverages chunks,some say only on import but no export. is that so?

Tharaka Dilshan Over a year ago

No, you CAN use FromQuery to export too, and its better than this approach too. But if you want to do that, you don't want to pass data through the constructor. you need to write database query in the query() function. If there are lot of data in the database I think thats the best solution.

Tharaka Dilshan Over a year ago

Not possible. If you wanna use FromQuery approach you have to provide a sql query to that query() function. Then they will take care of fetching data from the database (there's where they apply chunks). Otherwise you can't use FromQuery approach.

|

KazikM · Accepted Answer · 2020-12-07 17:42:35Z

0

You should use shouldQueue to export large data to an Excel file.

edited Dec 7, 2020 at 17:42

KazikM

1,3455 gold badges21 silver badges31 bronze badges

answered Dec 4, 2020 at 16:15

Sam

511 silver badge3 bronze badges

Comments

Anmol Mourya · Accepted Answer · 2019-11-04 13:54:52Z

-3

It Worked

In Query remove ->get() or replace with ->paginate(100)

with maatwebsite queue export.

answered Nov 4, 2019 at 13:54

Anmol Mourya

5605 silver badges7 bronze badges

Collectives™ on Stack Overflow

Laravel Excel 3.1 export large data

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

6 Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related