export-data-to-excel-csv-laravel

Export data to Excel or CSV in Laravel 5.3

In some big applications need export to excel or csv functionality is required. This article explains export excel or CSV data from database table. For doing this i used ‘maatwebsite/excel’  library. Simply follow below steps.

step 1 : Installation

Open composer and add below line of code.

Update composer i.e., Run the command ‘composer update

step 2 : Add service provider and aliase

Open ‘config/app.php’ and add below code.

Then ,  run ‘php artisan vendor:publish‘ command.

step 3 : Create table and model

Create model file name as app/States.php and copy below code.

step 4 : Routing

step 5 : Controller

(app/Http/Controllers/ExportToExcelCSVController.php)

step 6 : Views

(resources/views/export/index.blade.php)

Sample Screen short :

expotr-to-excel-csv-laravel