Generate csv file using laravel

Question

I searched in google to generate the csv file from laravel and i have found the following code:

  public function download(){
  $headers = [
    'Cache-Control'       => 'must-revalidate, post-check=0, pre-  check=0'
    ,   'Content-type'        => 'text/csv'
    ,   'Content-Disposition' => 'attachment; filename=galleries.csv'
    ,   'Expires'             => '0'
    ,   'Pragma'              => 'public'
   ];

$list = User::all()->toArray();

# add headers for each column in the CSV download
array_unshift($list, array_keys($list[0]));

$callback = function() use ($list) 
{
    $FH = fopen('php://output', 'w');
    foreach ($list as $row) { 
        fputcsv($FH, $row);
    }
    fclose($FH);
 };

return Response::stream($callback, 200, $headers);
}

In the above code, i didn't understand

$callback = function() use ($list){...}

will someone please explain me?

It's creating a callback function and assigning that function to a variable; that variable is then being passed as an argument to Response::stream() and Response::stream() will be able to execute that function — Mark Baker
– Mark Baker, Commented Apr 12, 2016 at 9:10
I'd strongly recommend using Laravel Excel - maatwebsite.nl/laravel-excel/docs It provides a nice wrapper for the functionality you are looking for. — andrew-caulfield
– andrew-caulfield, Commented Apr 12, 2016 at 9:12

Matt · Accepted Answer · 2016-04-12 09:25:17Z

2

Save yourself a world of trouble and use this library: http://www.maatwebsite.nl/laravel-excel/docs

It can convert your data to csv, excel and all other sorts of goodies. It's especially good with larger datasets.

Cause it's all fun and games when you open your csv in the same program on the same OS. But as soon as your client uses Libre, Open or just Office op MS or Mac your world will go to new depths of hell in multiple layers.

This library standardises csv for as far as possible and you will love it.

answered Apr 12, 2016 at 9:25

Matt

1,13116 silver badges28 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:19:26Z

0

I've recently discovered the 'league/csv' package - have written a S.O post about my usage (a simple example) here: CSV export in laravel 5 controller

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Sep 24, 2016 at 7:27

Rob

1,2806 gold badges25 silver badges36 bronze badges

Collectives™ on Stack Overflow

Generate csv file using laravel

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related