How to export data to excel in Laravel 8

How to export data to excel in Laravel 8

Shani Singh's photo
Shani Singh
·Feb 15, 2022·

1 min read

Export Laravel Excel

Export Data to Excel Files in Laravel 8

Today I am Going To Explain to you how you can Export Excel Files in Laravel 8.

I am going to use Tech-Admin Panel for this.

For Exporting an excel file I am using Laravel Excel.

You can read about Laravel Import From CSV/ Excel Files Here!

Step 1 - Installation

To Install the Laravel Excel Package via composer run command below.

composer require maatwebsite/excel

Next to export config file you need run command below.

php artisan vendor:publish --provider="Maatwebsite\Excel\ExcelServiceProvider" --tag=config

Step 2 - Create an Exports Class inside app/Exports

Create Exports Class by using artisan command

php artisan make:export UsersExport --model=User

Step 3 - Handle Export To Excel Function

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

You can watch the explanation video for more clarity.

Thank You for Reading

In case of any query related to LARAVEL.

Reach Out To me. Twitter Instagram YouTube

 
Share this