racklin / excel-generator
simple excel generator for laravel 5
Installs: 1 098
Dependents: 0
Suggesters: 0
Security: 0
Stars: 3
Watchers: 2
Forks: 3
Open Issues: 1
Requires
- php: >=5.4.0
- illuminate/support: 5.*
- nicmart/string-template: ~0.1
- phpoffice/phpexcel: 1.8.*
This package is auto-updated.
Last update: 2024-11-04 12:18:29 UTC
README
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+.