Download xlsx file without Headers, Vuejs

Question

I have a download action, that it works, but in my .xlsx file I don't have the header, and I am not sure how can I get them. I'm using Vuejs / Axios with Laravel.

<a type="button" class="mr-3" href="/json/persons/export" download="file.xlsx">
<button @click="exportCSV" class="btn btn-primary">
    Export CSV
</button>
</a>

exportCSV() {
    axios
    .get("/json/persons/export", {
        params: {
        sort_by: this.sortBy,
        sort_direction: this.sortDesc
        }
    })
    .then(response => {
        //
    })
    .catch(error => {
        //
    });
},

Export Class Code

namespace App\Exports;
use App\ViewData;
use Maatwebsite\Excel\Concerns\FromCollection;
use Excel;

class DataExport implements FromCollection
{
    public function collection()
    {
        return ViewData::all();
    }

}

Akhtar Munir · Accepted Answer · 2020-06-01 08:07:55Z

1

Well you can actually do something like

namespace App\Exports;
use App\ViewData;
use Maatwebsite\Excel\Concerns\FromCollection;
use Maatwebsite\Excel\Concerns\WithHeadings;
use Excel;

class DataExport implements FromCollection, WithHeadings
{
    public function collection()
    {
        return ViewData::all();
    }

    //Define your desired headings this way, it's just for an example
    public function headings(): array
    {
       return [
           'Name',
           'Surname',
           'Email',
           'Twitter',
       ];
    }
}

answered Jun 1, 2020 at 8:07

Akhtar Munir

1,7693 gold badges13 silver badges29 bronze badges

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

3 Comments

Beusebiu Over a year ago

Best, thank's a lot! Ps. I think that you should place an answer to the other question.

Akhtar Munir Over a year ago

Yeah let me place answer to the question as well. Welcome

Akhtar Munir Over a year ago

Posted that answer to your question too. please check that as well

Collectives™ on Stack Overflow

Download xlsx file without Headers, Vuejs

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related