[](https://packagist.org/packages/rap2hpoutre/fast-excel) [](https://packagist.org/packages/rap2hpoutre/fast-excel) [](https://travis-ci.org/rap2hpoutre/fast-excel) [](https://scrutinizer-ci.com/g/rap2hpoutre/fast-excel/?branch=master) [](https://www.codacy.com/app/rap2hpoutre/fast-excel?utm_source=github.com&utm_medium=referral&utm_content=rap2hpoutre/fast-excel&utm_campaign=Badge_Grade) [](https://packagist.org/packages/rap2hpoutre/fast-excel) Fast Excel import/export for Laravel, thanks to [Spout](https://github.com/box/spout). See [benchmarks](#benchmarks) below. ## Quick start Install via composer: ``` composer require rap2hpoutre/fast-excel ``` Export a Model to `.xlsx` file: ```php use Rap2hpoutre\FastExcel\FastExcel; use App\User; // Load users $users = User::all(); // Export all users (new FastExcel($users))->export('file.xlsx'); ``` ## Export Export a Model or a **Collection**: ```php $list = collect([ [ 'id' => 1, 'name' => 'Jane' ], [ 'id' => 2, 'name' => 'John' ], ]); (new FastExcel($list))->export('file.xlsx'); ``` Export `xlsx`, `ods` and `csv`: ```php $invoices = App\Invoice::orderBy('created_at', 'DESC')->get(); (new FastExcel($invoices))->export('invoices.csv'); ``` Export only some attributes specifying columns names: ```php (new FastExcel(User::all()))->export('users.csv', function ($user) { return [ 'Email' => $user->email, 'First Name' => $user->firstname, 'Last Name' => strtoupper($user->lastname), ]; }); ``` Download (from a controller method) ```php return (new FastExcel(User::all()))->download('file.xlsx'); ``` ## Import `import` returns a Collection: ```php $collection = (new FastExcel)->import('file.xlsx'); ``` Import a `csv` with specific delimiter and enclosure characters. ```php $collection = (new FastExcel)->configureCsv(';', '#')->import('file.csv'); ``` Import and insert to database: ```php $users = (new FastExcel)->import('file.xlsx', function ($line) { return User::create([ 'name' => $line['Name'], 'email' => $line['Email'] ]); }); ``` ## Advanced usage ### Export multiple sheets Export multiple sheets by creating a `SheetCollection`: ```php $sheets = new SheetCollection([ User::all(), Project::all() ]); (new FastExcel($sheets))->export('file.xlsx'); ``` Use index to specify sheet name: ```php $sheets = new SheetCollection([ 'Users' => User::all(), 'Second sheet' => Project::all() ]); ``` ### Import multiple sheets Import multiple sheets by using `importSheets`: ```php $sheets = (new FastExcel)->importSheets('file.xlsx'); ``` You can also import a specific sheet by its number: ```php $users = (new FastExcel)->sheet(3)->import('file.xlsx'); ``` ## Why? FastExcel is intended at being Laravel-flavoured [Spout](https://github.com/box/spout): a simple, but elegant wrapper around [Spout](https://github.com/box/spout) with the goal of simplifying **imports and exports**. It could be considered as a faster (and memory friendly) alternative to [Laravel Excel](https://laravel-excel.maatwebsite.nl/), with **many less** features. Use it only for very simple tasks. ## Benchmarks > Tested on a MacBook Pro 2015 2,7 GHz Intel Core i5 16 Go 1867 MHz DDR3. Testing a XLSX export for 10000 lines, 20 columns with random data, 10 iterations, 2018-04-05. **Don't trust benchmarks.** | | Average memory peak usage | Execution time | |---|---|---| | Laravel Excel | 123.56 M | 11.56 s | | FastExcel | 2.09 M | 2.76 s | Still, remember that [Laravel Excel](https://laravel-excel.maatwebsite.nl/) **has many more feature.** Please help me improve benchmarks, more tests are coming. Feel free to criticize.