Wallogit.com
2017 © Pedro Peláez
A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout
No plans for further development and/or support. This is just an experiment to improve the Laravel-Excel library., (*1)
A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout., (*2)
composer require maatwebsite/laravel-excel-light
Add the Service Provider in app.php, (*3)
```$xslt Maatwebsite\ExcelLight\LaravelExcelServiceProvider::class, (*4)
The Excel class can be injected in your service:
public function __construct(\Maatwebsite\ExcelLight\Excel $excel), (*5)
Optionally you can also inject the Reader and Writer:
public function __construct(\Maatwebsite\ExcelLight\Reader $reader) public function __construct(\Maatwebsite\ExcelLight\Writer $writer), (*6)
## Reading ### Fluent usage: ```php $excel->load(storage_path('workbook.xlsx'), function (Reader $reader) { $reader->sheets(function (Sheet $sheet) { $sheet->rows(function (Row $row) { // Get a column $row->column('heading_key'); // Magic get $row->heading_key; // Array access $row['heading_key']; }); }); });
$reader = $excel->load(storage_path('workbook.xlsx'));
foreach ($reader->sheets() as $sheet) {
foreach ($sheet->rows() as $row) {
$row->column('heading_key');
foreach ($row->cells() as $cell) {
}
}
}
$excel->create(function (Writer $writer) {
$writer->sheet('sheet1', function (Writer $sheet) {
$sheet->rows([
[1, 2, 3],
[4, 5, 6]
]);
// Add more rows
$sheet->rows([
[7, 8, 9],
[10, 11, 12]
]);
});
})->export(storage_path('workbook.xlsx'));
Registering a customer reader:, (*7)
$this->app->make(\Maatwebsite\ExcelLigt\ExcelManager::class)
->registerReader('driverName', function() {
return YourReader();
});
Registering a customer writer:, (*8)
$this->app->make(\Maatwebsite\ExcelLigt\ExcelManager::class)
->registerWriter('driverName', function() {
return YourWriter();
});
Resolving a custom reader and writer:, (*9)
__construct(ExcelManager $manager) {
$reader = $manager->reader('driverName');
$writer = $manager->writer('driverName');
}
A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout
MIT
laravel csv read write excel xls export import ods spout xlxs