How to export eloquent result to Excel using Maatwebsite ?

Hello

I have this simple controller bellow :

<?php

namespace App\Http\Controllers;

use App\User;
use Illuminate\Http\Request;

class excelTest extends Controller
{
    public function index(){
        $user = User::where('id','>',150)->get();
        return $user;
    }
}

I would like to download this result as excel file using Maatwebsite.

Thanks

Sti3bas

6 years ago

Level 53

@mostafalaravel just follow the docs: https://docs.laravel-excel.com/3.1/exports/

GodziLaravel

6 years ago

Level 8

Thanks @sti3bas

How to send $request->all() parameters to competenceExport class ?

    public function competencesExport(Request $request){
        return Excel::download(new CompetencesExport(), 'competences.xlsx');
    }

competenceExport class :


class CompetencesExport implements FromCollection
{
    /**
    * @return \Illuminate\Support\Collection
    */

    public function collection()
    {
        return competence::all();
    }
}

Sti3bas

6 years ago

Best Answer

Level 53

@mostafalaravel what about:

public function competencesExport(Request $request){
   return Excel::download(new CompetencesExport($request->all()), 'competences.xlsx');
}

class CompetencesExport implements FromCollection
{
   protected $params = [];

   public function __construct($params)
   {
      $this->params = $params;
   }

   public function collection()
   {
      return competence::all();
   }
}

Please or to participate in this conversation.