Import and export excel files, csv with Laravel-Excel
Bài đăng này đã không được cập nhật trong 6 năm
In this article, I will give a brief overview of the Laravel-Excel package . Perhaps there is no need to explain much about its purpose, the title says everything. Basically, Laravel Excel has the power of PHPExcel , it includes features like: importing Excel, CSV to collection, exporting models, array's or views to Excel, importing multiple files, etc.
Some outstanding features of Laravel Excel
- Import excel file, csv into Laravel Collections
- Export Blade views to Excel and CSV with CSS styling
- Import multiple files
- Support caching
- Support chunk and queues importer
- Fix Excel file, csv
- Many optional configuration settings in the config file
- And many other features
Use Laravel Excel
1 - Installation
- Install with composer
composer require maatwebsite/excel
- After installation is complete, open the file config / app.php and add the following code.
'providers' => [
....
Maatwebsite\Excel\ExcelServiceProvider::class,
],
'aliases' => [
....
'Excel' => Maatwebsite\Excel\Facades\Excel::class,
],
- Public configuration settings:
php artisan vendor:publish
The above settings will add excel.php file to the config message.
2 - Import
Laravel Excel can import multiple files, xls, xlsx, CSV files, worksheets into Laravel collections.
- Importing a file
Excel::load('file.xls', function($reader) {
// reader methods
});
- Import a folder
Excel::batch('folder', function($rows, $file) {
// Explain the reader how it should interpret each row,
// for every file inside the batch
$rows->each(function($row) {
// Example: dump the firstname
dd($row->firstname);
});
});
- Import multiple files
$files = [
'file1.xls',
'file2.xls'
];
Excel::batch($files, function($rows, $file) {
});
- Edit File Contents
Excel::load('file.csv', function($file) {
// modify
})->export('csv');
- Convert file
Excel::load('file.csv', function($file) {
// modify stuff
})->convert('xls');
3 - Export
Laravel Excel can create Excel or CSV files from Eloquent models and PHP array.
- Export to Excel5 (xls)
Excel::create('Filename', function($excel) {
})->export('xls');
// or
->download('xls');
- Export to Excel2007 (xlsx)
->export('xlsx');
// or
->download('xlsx');
- Export to CSV
->export('csv');
// or
->download('csv');
- Store on server
Excel::create('fileName', function($excel) {
// Set sheets
})->store('xls');
- Creating a sheet
Excel::create('Filename', function($excel) {
$excel->sheet('Sheetname', function($sheet) {
// Sheet manipulation
});
})->export('xls');
4 - @Blade to Excel
You can use Laravel's Blade to export the excel file, share a view, load a view to the sheet or create an html table inside the view.
- Load a view to a sheet you use -> loadView ().
Excel::create('New file', function($excel) {
$excel->sheet('New sheet', function($sheet) {
$sheet->loadView('folder.view');
});
});
- Use different views for different sheets
Excel::create('New file', function($excel) {
$excel->sheet('First sheet', function($sheet) {
$sheet->loadView('view_first');
});
$excel->sheet('Second sheet', function($sheet) {
$sheet->loadView('view_second');
});
});
- Share the view for all sheets
Excel::shareView('folder.view')->create();
- Transmission into view
$sheet->loadView('view', ['key' => 'value']);
or
// Using normal with()
$sheet->loadView('view')
->with('key', 'value');
// using dynamic with()
$sheet->loadView('view')
->withKey('value');
Here are some basic features of Larave Excel. Hopefully this article will help you get to know a part about Laravel Excel.
Refer:
All rights reserved
Bình luận
Do you also want to learn Laravel in the Tech School?
Visit our Tech School Website (Although it's only in Japanese for now).
https://framgia.com/study-abroad/