Excel Export using laravel with vuejs

Question

I am Doting Excel export using Laravel with Vuejs, somehow the Code is returning true value but can not Download Excel file, if I do normal request it will download the file, but in axios request, it will not export the file

I am using php artisan make:export to export file

In App/Export/studentexport.php

public function collection()
{
    return Student_master::all();
}

then in controller i will do a function

public function export()
{
    return Excel::download(new StudentExport, 'users.xlsx');
}

In my Vue file i will write a code that cal call the controller and export the file

axios.get('api/export')
            .then(()=>{
                toast({
                    type: 'success',
                    title: 'Export the Data'
                })
            })
            .catch(()=> {
                toast({
                        type: 'warning',
                        title: 'Can not Export'
                        })
            })

but the result is like that

that will return True, I really don't know how to solve this,plase help me

Possibly this can help you stackoverflow.com/questions/50736657/… — Robbin Benard
– Robbin Benard, Commented Jun 29, 2019 at 18:10

yurianxdev · Accepted Answer · 2020-01-08 07:03:37Z

3

I think is a little bit late but I had the same problem and I just solved it.

For download a file from vuejs, you shouldn't make the request as an Axios petition (at least not that I know). Instead, you can use a href and download attribute inside your template.

This is an example:

<a
    type="button"
    href="/api/export/entity/"
    download="file.xlsx"
>
    <button
        @click="export()"
        class="btn btn-primary"
    >
    Export
    </button>
</a>

The method helps if you need to do another stuff.

I hope this help you.

edited Jan 8, 2020 at 7:03

answered Jan 8, 2020 at 6:35

yurianxdev

518 bronze badges

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

1 Comment

Joney Spark Over a year ago

It's Works for me

dhruvin prajapati · Accepted Answer · 2019-07-02 11:20:07Z

2

ok I solve the problem, I use Vue-excel-export package that will Export the Excel File

enter link description here

this link can help me to install package and use it

answered Jul 2, 2019 at 11:20

dhruvin prajapati

3311 gold badge4 silver badges17 bronze badges

Comments

Tarun Korat · Accepted Answer · 2024-10-18 10:13:04Z

0

I faced the same issue when I was using Inertia, Laravel, or Vue project. But i found the solution.

 exportData() {
            // Construct the download URL with query parameters
            const query = new URLSearchParams({
                search: this.searchQuery,
                sales_persons: this.searchSalesPerson,
                products: this.searchProduct,
                material_types: this.searchMaterial,
                export: 'true'
            }).toString();

            // Trigger the browser to navigate to the download URL
            window.location.href = this.route('module-certificate.index') + '?' + query;
},

answered Oct 18, 2024 at 10:13

Tarun Korat

214 bronze badges

Collectives™ on Stack Overflow

Excel Export using laravel with vuejs

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related