irain/export-excel

This package is abandoned and no longer maintained. The author suggests using the export-exce package instead.

Simple & Faster Export Excel

1.10.2 2017-11-13 05:16 UTC

Requires

• cache/apcu-adapter: ^1.0
• cache/memcache-adapter: ^1.0
• cache/redis-adapter: ^1.0
• cache/simple-cache-bridge: ^1.0

Requires (Dev)

• mockery/mockery: 1.0.x-dev
• phpoffice/phpspreadsheet: ~1.0.0beta
• phpunit/phpunit: ^5.7

MIT

• motecshine

README

`Export Excel` is a simple & faster exports table tool.

How To Install

composer require irain/export-excel

Dependency

"cache/simple-cache-bridge": "^1.0",
"cache/redis-adapter": "^1.0",
"cache/apcu-adapter": "^1.0",
"cache/memcache-adapter": "^1.0"
"phpoffice/phpspreadsheet" : "~1.0.0beta"

Example

Export

    use Irain\ExportExcel\Export;  
    $config = [
        'cache_driver' => [
            'name'   => 'redis',
            'server' => '127.0.0.1',
            'port'   => '6379',
        ],
        'path'         => DOWNLOAD_PATH,
        'writer'       => 'excel', // if empty default writer is `excel`
    ];

    $excelData = [
        ['green', '1']
    ];

    $fileName = 'export_file_name' . date('Y-m-d H:i:s', time());

    $export   = new Export($config);

    $export->fileName($fileName)
        ->header(['name', 'age'])
        ->data($excelData)
        ->output();
 

Import

    use Irain\ExportExcel\Import;  
    $importConfig = [
        'cache_driver' => [
            'name'   => 'redis',
            'server' => '127.0.0.1',
            'port'   => '6379',
        ],
        'writer'       => 'excel', // if empty default writer is `excel`
    ];

    $import = new \Irain\ExportExcel\Import($importConfig);
    $data = $import->setResource('/var/www/html/export_file_name.xls')
    ->header(['name', 'age'])
    ->resourceToArray();

Contributors

viest

License

Apache License 2.0