How to fix error when using query export to export large data in Laravel

Question

I want to export the big data (>10K) when I clicked the 'export button'. I tried to use the Yagra Datatable, however it only can export the current page for pagination. so i tried the query export Maatwebsite. What I did is when 'export' button is clicked, the result will be passed to the excel function and it will export the data into my local machine. My controller is like below:

public function filterQuery(Request $request)
{
    $dataGender = $request->dataGender;
    $ethnicity = $request->ethnicity;



What should I fix so that when I clicked the button, the query will export the result into CSV?

Community · Accepted Answer · 2020-06-20 09:12:55Z

0

excel() takes 2 parameters. Request $request is sent automatically, but $type is not.

function excel(Request $request, $type) { ... }

Your uri /custom doesn't have a parameter, so the only way to send type is by appending it as a GET parameter. (eg. /custom?type=some_type)

Your options:

Put a default value in your excel() function.

function excel(Request $request, $type = 'default') { ... }

Pass a value on your route.

<a href="{{ route('export_excel.excel') }}?type=some_type" class="btn btn-success">Export to Excel</a>

Remove $type parameter.

function excel(Request $request, $type)
function excel(Request $request)
{
    return Excel::create('FILENAME', function ($excel) use ($data) {
        $excel->sheet('mySheet', function ($sheet) use ($data) {
            $sheet->fromArray($data);
        });
    })->download($type);
    })->download('default');
}

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Feb 3, 2020 at 6:52

IGP

16.4k5 gold badges34 silver badges55 bronze badges

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

5 Comments

swm Over a year ago

Undefined variable: data, at excel function

IGP Over a year ago

I'm assuming you get your $data some way. Just define $data = ... before the return.

swm Over a year ago

The problem is actually I dont really sure how to pass the $data from query filterQuery() , so the array will be exported using excel()

IGP Over a year ago

That's not really an error. Can't you copy the query directly?

swm Over a year ago

I've copied the code, but system lag once I run. I think it query all the data from ModifiedDppr table, so thats why its slow.

Collectives™ on Stack Overflow

How to fix error when using query export to export large data in Laravel

1 Answer 1

Your options:

5 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your options:

5 Comments

Your Answer

Sign up or log in

Post as a guest

Related