How to download Laravel Excel with Ajax method

Question

I'm working on Laravel Excel using Ajax method. Below is my controller.

 public function downloadExcel(){
    return Excel::download(new SomeExport(), 'project.xlsx');
 }

And this is ajax call.

$(document).on('click', '#download_excel', function(e) {
    downloadExcel().then(data => {
        //may be need to do some here.
    }).catch(error => {})
});

function downloadExcel() {
    return new Promise((resolve, reject) => {
        $.ajax({
            url: `${route.url}/api/...`,
            type: 'GET',
            headers: {"X-CSRF-TOKEN":route.token},
            success: function(data) {
            resolve(data)
            },
            error: function(error) {
            reject(error)
            },
        })
    })
}

This work for normal request but not work for ajax. Any advice or guidance on this would be greatly appreciated, Thanks.

you can use https://laravel.com/docs/8.x/responses#file-downloads — Kamlesh Paul, Feb 11 '21 at 06:20

score 1 · Accepted Answer · answered Feb 11 '21 at 07:35

1

I've tried this, and it works.

$(document).on('click', '#download_excel', function(e) {
    window.location="{{ route('yourRoute')}}";
})

answered Feb 11 '21 at 07:35

Skematografi

66
1

But this is not ajax, not answering the question. – ronrun Jul 05 '22 at 14:56

How to download Laravel Excel with Ajax method

1 Answers1