An eloquent way of importing and exporting Excel and CSV in Laravel 4 with the power of PHPExcel

Installs: 321 103

Dependents: 20

Stars: 1 288

Watchers: 75

Forks: 259

Open Issues: 32

Language: PHP


README

Laravel Excel v2.0.0 for Laravel 5

Looking for Laravel Excel for Laravel 4? Visit the 1.3 branch

687474703a2f2f7777772e6d6161747765627369 1b495af2-bb84-11e4-9a93-34a9abc01840.jpg

Laravel Excel brings the power of PHPOffice's PHPExcel to Laravel 5 with a touch of the Laravel Magic. It includes features like: importing Excel and CSV to collections, exporting models, array's and views to Excel, importing batches of files and importing a file by a config file.

  • Import into Laravel Collections
  • Export Blade views to Excel and CSV with optional CSS styling
  • Batch imports
  • A lot of optional config settings
  • Easy cell caching
  • Chunked importer
  • ExcelFile method injections
  • Editing existing Excel files
  • Advanced import by config files
  • and many more...
Excel::create('Laravel Excel', function($excel) {

    $excel->sheet('Excel sheet', function($sheet) {

        $sheet->setOrientation('landscape');

    });

})->export('xls');

Build Status Latest Stable Version Total Downloads License Monthly Downloads Daily Downloads

Require this package in your composer.json and update composer. This will download the package and PHPExcel of PHPOffice.

"maatwebsite/excel": "~2.0.0"

After updating composer, add the ServiceProvider to the providers array in config/app.php

'Maatwebsite\Excel\ExcelServiceProvider',

You can use the facade for shorter code. Add this to your aliases:

'Excel' => 'Maatwebsite\Excel\Facades\Excel',

The class is bound to the ioC as excel

$excel = App::make('excel');

To publish the config settings in Laravel 5 use:

php artisan vendor:publish

This will add an excel.php config file to your config folder.

Documentation

The complete documentation can be found at: http://www.maatwebsite.nl/laravel-excel/docs

Support

Support only through Github. Please don't mail us about issues, make a Github issue instead.

Contributing

ALL bug fixes should be made to appropriate branch (e.g. 2.0 for 2.0.* bug fixes). Bug fixes should never be sent to the master branch.

More about contributing can be found at: http://www.maatwebsite.nl/laravel-excel/docs/getting-started#contributing

License

This package is licensed under LGPL. You are free to use it in personal and commercial projects. The code can be forked and modified, but the original copyright author should always be included!