Create Import and Export class using import/export command
Note: This command avaialble only if you download dependecy successfully using composer(step 1)
php artisan make:export
BulkExport --model=Bulk
In app/Emports/BulkExport.php file
namespace App\Exports;
use App\Bulk;
use Maatwebsite\Excel\Concerns\FromQuery;
use Maatwebsite\Excel\Concerns\WithHeadings;
class BulkExport implements FromQuery,WithHeadings
{
/**
* @return \Illuminate\Support\Collection
*/
// use Exportable;
public function headings(): array
{
return [
'Id',
'name',
'email',
'createdAt',
'updatedAt',
];
}
public function query()
{
return Bulk::query();
/*you can use condition in query to get required result
return Bulk::query()->whereRaw('id > 5');*/
}
public function map($bulk): array
{
return [
$bulk->id,
$bulk->name,
$bulk->email,
Date::dateTimeToExcel($bulk->created_at),
Date::dateTimeToExcel($bulk->updated_at),
];
}
}
A simple, but elegant Laravel wrapper around PhpSpreadsheet exports and imports.
Quickstart · Documentation ·
Video Course · Nova · Blog · Contributing ·
Support
✨ Features
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.
🎓 Learning Laravel Excel
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/SpartnerNL/laravel-excel-docs.
Some articles and tutorials can be found on our blog:
https://medium.com/maatwebsite/laravel-excel/home
📬 License & Postcardware
Laravel Excel is created with love and care by Spartner (formerly known as Maatwebsite) to give back to the Laravel community. It is completely free (MIT license) to use, however
the package is licensed as Postcardware. This means that if it makes it to your production environment, we would very much appreciate receiving a postcard from your hometown.
Spartner Markt 2 6231 LS Meerssen The Netherlands.
More about the license can be found at: https://docs.laravel-excel.com/3.1/getting-started/license.html
Created by Spartner (formerly Maatwebsite)
We are a strategic development partner, creating web-based custom built software from Laravel. In need of a digital solution for your challenge? Give us a call.
https://spartner.software +31 (0) 10 - 7449312
🔧 Supported Versions
Versions will be supported for a limited amount of time.
