Using Excel in Laravel5

http://www.maatwebsite.nl/laravel-excel/docs/getting-started
Https://packagist.org/packages/maatwebsite/excel

Download

Update composer
or directly on the command line.

require maatwebsite/excel

2 configuration

app/config/app.php
The providers array is added
Maatwebsite\excel\excelserviceprovider::class,
The aliasses array is added:
' Excel ' = Maatwebsite\excel\facades\excel::class,

3. Use

    namespaceApp\Http\Controllers; UseIlluminate\Http\Request; UseApp\Http\Requests; UseApp\Http\Controllers\Controller; UseMaatwebsite\Excel\Facades\Excel; classdemocontrollerextendsController{ Public functiongetdemo(){returnView"Demo.demo"); } Public functiongetexcel(){//$excel = App::make (' Excel ');Excel::create (' Laravel Excel ', function($excel) {$excel->sheet (' Excel sheet ', function($sheet) {$sheet->setorientation (' Landscape ');        }); })->export (' xls '); }}

Export Excel API Address
Http://www.maatwebsite.nl/laravel-excel/docs/export
Import Excel API Address
Http://www.maatwebsite.nl/laravel-excel/docs/import

'). addclass (' pre-numbering '). Hide (); $ (this). addclass (' has-numbering '). Parent (). append ($numbering); for (i = 1; i <= lines; i++) {$numbering. Append ($ ('

'). Text (i)); }; $numbering. FadeIn (1700); }); });

The above describes the use of Excel in Laravel5, including the require aspects of the content, I hope that the PHP tutorial interested in a friend helpful.

