This is for a single use case currently but we are hoping to release modified framework at some point.
Laravel Excel brings the power of PHPOffice's PHPExcel to Herbert (custom) 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');
Add the repository to your composer.json
to include the following repository:
"repositories": [
{
"type": "vcs",
"url": "https://github.com/techniquedm/Laravel-Excel"
}
],
Then add the require for the dev-wp
branch:
"require": {
"techniquedm/Laravel-Excel": "dev-wp"
},
Run composer update. The rest of these instructions are not completely accurate due to the differences in the Herbert and Laravel frameworks however they are close enough to point you in the right direction if you're attempting this for some reason...
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.
The complete documentation can be found at: http://www.maatwebsite.nl/laravel-excel/docs
Support only through Github. Please don't mail us about issues, make a Github issue instead.
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
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!
- Chunk importer only imports the first row
Check that auto_detect_line_endings in your php.ini is set to true.