通过以下链接搜索 
racklin / excel-generator
为Laravel 5设计的简单Excel生成器
dev-master
2017-09-01 08:47 UTC
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-09-04 11:57:42 UTC
README
使用phpexcel库的Laravel简单Excel生成器。
此包使用json作为模板，您可以通过传递php数组作为数据来生成Excel xlsx文件。
安装
{
"require": {
"racklin/excel-generator": "dev-master"
}
}
接下来，将服务提供者添加到config/app.php文件中。
'providers' => [ //... Racklin\ExcelGenerator\ServiceProvider::class, ] //... 'aliases' => [ //... 'ExcelGen' => Racklin\ExcelGenerator\Facades\ExcelGenerator::class ]
示例
$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版本
当前包版本适用于Laravel 5+。