Friday, April 14, 2017

setColumnFormat Excel File

I try to format a column Date with

$sheet->setColumnFormat(array('E' => 'dd-mm-yyyy'));

But the date still display like : yyyy/mm/dd

Someone nows how i could resolve the problem ? Thanks a lot in advance

public function build() {

    $licencies = Licencies::where('lb_assurance' , '=' , 'Lafont')
        ->leftJoin('activite_licencie' , 'activite_licencie.id' , '=' , 'licencies.activite_licencie_id')
        ->leftJoin('saisons' , 'saisons.id' , '=' , 'licencies.saison_id')
        ->leftJoin('pays' , 'pays.id' , '=' , 'licencies.pays_naissance_id')
        ->leftJoin('type_licence' , 'type_licence.id' , '=' , 'licencies.type_licence_id')
        ->leftJoin('structures' , 'structures.id' , '=' , 'licencies.structure_id')
        ->leftJoin('civilite' , 'civilite.id' , '=' , 'licencies.civilite_id')
        ->select('civilite.lb_civilite' , 'num_licence' , 'lb_nom' , 'lb_prenom' , 'dt_naissance' , 'pays.fr' ,'activite_licencie.lb_activite'  ,'saisons.lb_saison', 'lb_surclassement' ,  'structures.nom_structure' , 'lb_assurance' , 'cd_dept_naissance' , 'licencies.created_at')
        //->whereRaw('DATE(licencies.created_at) = CURRENT_DATE')
        ->get();

        $excel_file = Excel::create('DailyRecapLicencesLafont', function($excel) use ($licencies) {
        $excel->sheet('Excel', function($sheet) use ($licencies)
        {
            $sheet->fromArray($licencies);
            $sheet->setColumnFormat(array('E' => 'dd-mm-yyyy'));

        });

    });

            return $this->markdown('email.licences.lafont')
                ->subject('Nouvelles Licences Saisies sur FRXIII Licences avec Assurance Lafont')
                ->attach($excel_file->store("xlsx", false, true)['full']);;

}



via Mathieu Mourareau

Advertisement