Excel Generator for Laravel
Switch branches/tags
Nothing to show
Clone or download
Pull request Compare This branch is even with racklin:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
samples
src/Racklin/ExcelGenerator
.gitignore
LICENSE
README.md
composer.json

README.md

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/