2017 © Pedro Peláez
 

library excel-m

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

image

ouarea/excel-m

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  • Friday, April 20, 2018
  • by linojiang268
  • Repository
  • 1 Watchers
  • 1 Stars
  • 440 Installations
  • PHP
  • 0 Dependents
  • 0 Suggesters
  • 9 Forks
  • 0 Open issues
  • 10 Versions
  • 121 % Grown

The README.md

Laravel Excel Light

No plans for further development and/or support. This is just an experiment to improve the Laravel-Excel library., (*1)

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout., (*2)

Installation

composer require maatwebsite/laravel-excel-light

Add the Service Provider in app.php, (*3)

```$xslt Maatwebsite\ExcelLight\LaravelExcelServiceProvider::class, (*4)


The Excel class can be injected in your service:

public function __construct(\Maatwebsite\ExcelLight\Excel $excel), (*5)


Optionally you can also inject the Reader and Writer:

public function __construct(\Maatwebsite\ExcelLight\Reader $reader) public function __construct(\Maatwebsite\ExcelLight\Writer $writer), (*6)


## Reading ### Fluent usage: ```php $excel->load(storage_path('workbook.xlsx'), function (Reader $reader) { $reader->sheets(function (Sheet $sheet) { $sheet->rows(function (Row $row) { // Get a column $row->column('heading_key'); // Magic get $row->heading_key; // Array access $row['heading_key']; }); }); });

Classic usage:

$reader = $excel->load(storage_path('workbook.xlsx'));

foreach ($reader->sheets() as $sheet) {
    foreach ($sheet->rows() as $row) {

        $row->column('heading_key');

        foreach ($row->cells() as $cell) {

        }
    }
}

Writing

$excel->create(function (Writer $writer) {
    $writer->sheet('sheet1', function (Writer $sheet) {
        $sheet->rows([
            [1, 2, 3],
            [4, 5, 6]
        ]);

        // Add more rows
        $sheet->rows([
            [7, 8, 9],
            [10, 11, 12]
        ]);
    });
})->export(storage_path('workbook.xlsx'));

Custom Readers and Writers

Registering a customer reader:, (*7)

$this->app->make(\Maatwebsite\ExcelLigt\ExcelManager::class)
    ->registerReader('driverName', function() {
        return YourReader();
    });

Registering a customer writer:, (*8)

$this->app->make(\Maatwebsite\ExcelLigt\ExcelManager::class)
    ->registerWriter('driverName', function() {
        return YourWriter();
    });

Resolving a custom reader and writer:, (*9)

__construct(ExcelManager $manager) {
    $reader = $manager->reader('driverName');
    $writer = $manager->writer('driverName');
}

The Versions

20/04 2018

dev-master

9999999-dev

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Maatwebsite.nl

laravel csv read write excel xls export import ods spout xlxs

20/04 2018

v1.0.5

1.0.5.0

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Maatwebsite.nl

laravel csv read write excel xls export import ods spout xlxs

20/04 2018

dev-develop

dev-develop

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Maatwebsite.nl

laravel csv read write excel xls export import ods spout xlxs

20/04 2018

dev-release/v1.0.5

dev-release/v1.0.5

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Maatwebsite.nl

laravel csv read write excel xls export import ods spout xlxs

20/04 2018

dev-release/v1.0.4

dev-release/v1.0.4

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Maatwebsite.nl

laravel csv read write excel xls export import ods spout xlxs

19/04 2018

v1.0.3

1.0.3.0

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Maatwebsite.nl

laravel csv read write excel xls export import ods spout xlxs

19/04 2018

dev-release/v1.0.3

dev-release/v1.0.3

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Maatwebsite.nl

laravel csv read write excel xls export import ods spout xlxs

19/04 2018

v1.0.2

1.0.2.0

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Maatwebsite.nl

laravel csv read write excel xls export import ods spout xlxs

19/04 2018

dev-release/v1.0.2

dev-release/v1.0.2

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Maatwebsite.nl

laravel csv read write excel xls export import ods spout xlxs

19/04 2018

v1.0.1

1.0.1.0

A faster and more eloquent way of importing and exporting Excel and CSV in Laravel with the speed of Spout

  Sources   Download

MIT

The Requires

 

The Development Requires

by Maatwebsite.nl

laravel csv read write excel xls export import ods spout xlxs