racklin/excel-generator
Simple Excel Generator for Laravel
Simple Excel Generator for Laravel using phpexcel library.
This package using json as template and you can pass php array as data to generate Excel xlsx.
Installation
{
"require": {
"racklin/excel-generator": "dev-master"
}
}
Next, add the service provider to config/app.php.
'providers' => [
//...
Racklin\ExcelGenerator\ServiceProvider::class,
]
//...
'aliases' => [
//...
'ExcelGen' => Racklin\ExcelGenerator\Facades\ExcelGenerator::class
]
Example
$excel = new ExcelGenerator();
$excel->generate('example_01.json', ["name"=>"rack", "cname"=>"阿土伯", "data"=> [
["a"=>"A1", "b"=>"B1"],
["a"=>"A2", "b"=>"B2"],
["a"=>"A3", "b"=>"B2"],
["a"=>"A4", "b"=>"B2"],
["a"=>"A5", "b"=>"B2"],
["a"=>"A6", "b"=>"B2"],
["a"=>"A7", "b"=>"B2"],
["a"=>"A8", "b"=>"B2"],
["a"=>"A9", "b"=>"B2"],
]], '/tmp/example_01.xlsx', 'F');
Laravel Facade
ExcelGen::generate('example_01.json', ["name"=>"rack", "cname"=>"阿土伯", "data"=> [
["a"=>"A1", "b"=>"B1"],
["a"=>"A2", "b"=>"B2"],
["a"=>"A3", "b"=>"B2"],
["a"=>"A4", "b"=>"B2"],
["a"=>"A5", "b"=>"B2"],
["a"=>"A6", "b"=>"B2"],
["a"=>"A7", "b"=>"B2"],
["a"=>"A8", "b"=>"B2"],
["a"=>"A9", "b"=>"B2"],
]], '/tmp/example_01.xlsx', 'F');
Laravel version
Current package version works for Laravel 5+.