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+.

License

MIT: https://racklin.mit-license.org/