betalabs/excel

Supercharged Excel exports in Laravel

3.1.7 2019-02-14 18:17 UTC

Requires

• php: ^7.0
• ext-json: *
• illuminate/support: 5.5.*|5.6.*|5.7.*|5.8.*
• phpoffice/phpspreadsheet: ^1.6

Requires (Dev)

• mockery/mockery: ^1.1
• orchestra/database: ^3.7
• orchestra/testbench: ^3.7
• phpunit/phpunit: ^7.5
• predis/predis: ^1.1

MIT

• Patrick Brouwers

• php
• excel
• csv
• import
• export
• laravel
• batch
• PHPExcel
• phpspreadsheet

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

1. Chunk importer only imports the first row

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