馃帀 Celebrating 10 Million Downloads. Read more on our blog! about 5 years of Laravel!
Supercharged Excel exports and imports
A simple, but elegant wrapper around PhpSpreadsheet with the goal of simplifying
exports and imports.
Quickstart 路 Documentation 路 Nova 路 Blog 路 Contributing 路 Support
-
Easily export collections to Excel. Supercharge your Laravel collections and export them directly to an Excel or CSV document. Exporting has never been so easy.
-
Supercharged exports. Export queries with automatic chunking for better performance. You provide us the query, we handle the performance. Exporting even larger datasets? No worries, Laravel Excel has your back. You can queue your exports so all of this happens in the background.
-
Supercharged imports. Import workbooks and worksheets to Eloquent models with chunk reading and batch inserts! Have large files? You can queue every chunk of a file! Your entire import will happen in the background.
-
Export Blade views. Want to have a custom layout in your spreadsheet? Use a HTML table in a Blade view and export that to Excel.
馃挕 Require this package in the composer.json
of your Laravel project. This will download the package and PhpSpreadsheet.
composer require maatwebsite/excel
馃挭 Create an export class in App/Exports
php artisan make:export UsersExport --model=User
This should have created:
<?php
namespace App\Exports;
use App\User;
use Maatwebsite\Excel\Concerns\FromCollection;
class UsersExport implements FromCollection
{
public function collection()
{
return User::all();
}
}
馃敟 In your controller you can call this export now:
use App\Exports\UsersExport;
use Maatwebsite\Excel\Facades\Excel;
use App\Http\Controllers\Controller;
class UsersController extends Controller
{
public function export()
{
return Excel::download(new UsersExport, 'users.xlsx');
}
}
馃搫 Find your users.xlsx
in your downloads folder!
More installation instructions can be found at: https://laravel-excel.maatwebsite.nl/3.1/getting-started/installation.html
馃挭 Create an import class in App\Imports
You may do this by using the make:import
command.
php artisan make:import UsersImport --model=User
If you prefer to create the import manually, you can create the following in App\Imports
:
<?php
namespace App\Imports;
use App\User;
use Illuminate\Support\Facades\Hash;
use Maatwebsite\Excel\Concerns\ToModel;
class UsersImport implements ToModel
{
/**
* @param array $row
*
* @return User|null
*/
public function model(array $row)
{
return new User([
'name' => $row[0],
'email' => $row[1],
'password' => Hash::make($row[2]),
]);
}
}
馃敟 In your controller you can call this import now:
use App\Imports\UsersImport;
use Maatwebsite\Excel\Facades\Excel;
use App\Http\Controllers\Controller;
class UsersController extends Controller
{
public function import()
{
Excel::import(new UsersImport, 'users.xlsx');
return redirect('/')->with('success', 'All good!');
}
}
馃搫 Find the imported users in your database!
You can find the full documentation of Laravel Excel on the website.
We welcome suggestions for improving our docs. The documentation repository can be found at https://github.com/Maatwebsite/laravel-excel-docs.
Read some articles and tutorials can be found on our blog: https://laravel-excel.maatwebsite.nl/blog/
Versions will be supported for a limited amount of time.
Version | Laravel Version | Php Version | Support |
---|---|---|---|
2.1 | <=5.6 | <=7.0 | Unsupported since 15-5-2018 |
3.0 | ^5.5 | ^7.0 | Unsupported since 31-12-2018 |
3.1 | ^5.5 | ^7.0 | New features |
Our software is open source and licensed under the MIT license.
If you use the software in your production environment we would appreciate to receive a postcard of your hometown. Please send it to:
Maatwebsite
Florijnruwe 111-2
6218 CA Maastricht
The Netherlands
More about the license can be found at: https://laravel-excel.maatwebsite.nl/3.1/getting-started/license.html