export csv file from mysql database in laravel 5

Question

I have done import in laravel 5 but facing some problem while exporting file. code is not proper and doesnot give any logic. I have tried similiar to documentation

public function exportData(Test $test,Excel $excel){
  $test=$test->all();
    Excel::create('Test excel', function($test) {

    $test->sheet('sheet1', function($sheet) {

        $sheet->setOrientation('landscape');

    });

})->export('xls');
    }

how to export csv file from mysql? I am using "maatwebsite/excel": "~2.0.0" package

Jay Dhameliya · Accepted Answer · 2015-12-14 06:55:37Z

2

You can use INTO OUTFILE in Laravel

public function exportData($file_name) {

          $file = public_path()."/downloads/".$file_name; //CSV file is store this path

          $query = sprintf("select * from tests INTO OUTFILE '%s' FIELDS TERMINATED BY ',' ENCLOSED BY '\"' LINES TERMINATED BY '\n'",$file);

         \DB::connection()->getpdo()->exec($query);
    }

answered Dec 14, 2015 at 6:55

Jay Dhameliya

1,70912 silver badges25 bronze badges

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

2 Comments

sabin maharjan Over a year ago

i am using maatwebsite/excel package

morphatic Over a year ago

This solution does not require ANY external libraries. It can implemented in Laravel "as is."

morphatic · Accepted Answer · 2015-12-14 02:24:48Z

0

You might consider using the league/csv package. They have an example of exporting a database query to CSV. In your case, it would look something like:

public function exportData() {
    // get the data
    $data = Test::all();

    // get a Writer object for writing to CSV
    $csv = League\Csv\Writer::createFromFileObject(new SplTempFileObject());

    // add the data to the writer
    $csv->insertAll($data);

    // output the file
    $csv->output('testdata.csv');
}

answered Dec 14, 2015 at 2:24

morphatic

7,9854 gold badges52 silver badges65 bronze badges

2 Comments

sabin maharjan Over a year ago

i am using maatwebsite/excel package

morphatic Over a year ago

I see that you have edited your original post to include this information. That being said, is it absolutely necessary that you use that specific package? Both my answer and the answer by @jay-dhameliya will solve your problem rather easily.

Collectives™ on Stack Overflow

export csv file from mysql database in laravel 5

2 Answers 2

2 Comments

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related