README

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

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 and queued 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');

Installation

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

composer require "maatwebsite/excel:~2.1.0"

In Laravel 5.5 or higher, this package will be automatically discovered and you can safely skip the following two steps.

If using Laravel 5.4 or lower, after updating composer, add the ServiceProvider to the providers array in config/app.php

Maatwebsite\Excel\ExcelServiceProvider::class,

You can use the facade for shorter code; if using Laravel 5.4 or lower, add this to your aliases:

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

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 --provider="Maatwebsite\Excel\ExcelServiceProvider"

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

Documentation

The complete documentation can be found at: https://laravel-excel.maatwebsite.nl/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: https://laravel-excel.maatwebsite.nl/docs/2.1/getting-started/contributing

License

This package is licensed under MIT. 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!

FAQ

Chunk importer only imports the first row

Check that auto_detect_line_endings in your php.ini is set to true.

lewisliang82 / excel

Maintainers

Details