racklin/excel-generator

simple excel generator for laravel 5

dev-master 2017-09-01 08:47 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+.

License

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