clivern/lce

Export a Large CSV Files with Laravel.

Laravel CSV Export

Export a Large Dataset in CSV Format. It is based on Symfony’s StreamedResponse and Laravel’s chunked queries., _(*1)

Current version: [v1.0.4], _(*2)

Installation

Via Composer, _(*3)

``` bash $ composer require clivern/lce, <sub>(*4)</sub>

Then add the ServiceProvider to the providers array in `config/app.php`

```php
'providers' => [
    // ...
    Clivern\Lce\LceServiceProvider::class,
    // ...
],

You can use the facade for shorter code. Add this to your aliases:, <sub>(*5)</sub>

'aliases' => [
    // ...
    'Lce' => Clivern\Lce\Facades\Lce::class,
    // ...
],

The class is bound to the ioC as lce, <sub>(*6)</sub>

$lce = App::make('lce');

Usage

For Example Let's use it to export options table., <sub>(*7)</sub>

``` php namespace App\Http\Controllers;, <sub>(*8)</sub>

use App\Http\Controllers\Controller; use App\Models\Option; # Eloquent Model use Validator; use Input; use Illuminate\Http\Request; use Illuminate\Support\Facades\View;, <sub>(*9)</sub>

class HomeController extends Controller {, <sub>(*10)</sub>

public function indexRender()
{

    return \App::make('lce')
        ->file('options')
        ->source(new Option)
        ->chunks(10)
        ->header([["Id","Option Key","Option Value"], ['', '', '']])->callback(function($option){
            return [
                $option->id,
                $option->op_key,
                $option->op_value,
            ];
        })->export();
}

}, <sub>(*11)</sub>

## Change log

Version 1.0.4:, <sub>(*12)</sub>

Composer lock file added., <sub>(*13)</sub>

Version 1.0.3:, <sub>(*14)</sub>

New method to get CSV file content. New feature to add two rows in single return., <sub>(*15)</sub>

Version 1.0.2:, <sub>(*16)</sub>

Docs Updated., <sub>(*17)</sub>

Version 1.0.1:, <sub>(*18)</sub>

Docs Updated. UTF-8 Support Added., <sub>(*19)</sub>

Version 1.0.0:, <sub>(*20)</sub>

Initial Release. ```, <sub>(*21)</sub>

Security

If you discover any security related issues, please email hello@clivern.com instead of using the issue tracker., <sub>(*22)</sub>

License

The MIT License (MIT). Please see License File for more information., <sub>(*23)</sub>