cblink / laravel-excel-zip
Installs: 7 233
Dependents: 0
Suggesters: 0
Security: 0
Stars: 62
Watchers: 4
Forks: 2
Open Issues: 1
Requires
- chumper/zipper: ^1.0
- maatwebsite/excel: ^3.0
Requires (Dev)
- laravel/framework: ^5.6
This package is not auto-updated.
Last update: 2024-11-02 18:39:49 UTC
README
download excels wrap in zip
laravel-excel-zip is a solution to download a large excel. You can define when to chunk excels into a zip file.
Install
composer require cblink/laravel-excel-zip -vvv
Usage
run command to create config/excel_zip.php
php artisan vendor:publish --provider="Cblink\ExcelZip\ExcelZipServiceProvider"
Export
use CustomCollection in your Export
and Don't define collection
function
<?php use Cblink\ExcelZip\CustomCollection; use Maatwebsite\Excel\Concerns\FromCollection; class MemberExport implements FromCollection { use CustomCollection; }
Controller
<?php use Cblink\ExcelZip\ExcelZip; use App\Http\Controllers\Controller; class MemberController extends Controller { // chunk by database(better!) public function export1(ExcelZip $excelZip, MemberExport $export) { $excelZip = $excelZip->setExport($export); Member::chunk(5000, function ($members) use ($excelZip) { $excelZip->excel($members); }); return $excelZip->zip(); } // chunk in laravel-excel-zip public function export2(ExcelZip $excelZip, MemberExport $export) { return $excelZip->download(Member::all(), $export); } }