Download the PHP package gcordonpgva/sheet-excel-import without Composer

Fast Excel import/export for Laravel, thanks to Spout. See benchmarks below.

Quick start

Install via composer:

Export a Model to .xlsx file:

Export

Export a Model or a Collection:

Export xlsx, ods and csv:

Export only some attributes specifying columns names:

Download (from a controller method):

Import

import returns a Collection:

Import a csv with specific delimiter, enclosure characters and "gbk" encoding:

Import and insert to database:

Facades

You may use FastExcel with the optional Facade. Add the following line to config/app.php under the aliases key.

``

Using the Facade, you will not have access to the constructor. You may set your export data using the data method.

``

Global helper

FastExcel provides a convenient global helper to quickly instantiate the FastExcel class anywhere in a Laravel application.

Advanced usage

Export multiple sheets

Export multiple sheets by creating a SheetCollection:

Use index to specify sheet name:

Import multiple sheets

Import multiple sheets by using importSheets:

You can also import a specific sheet by its number:

Export large collections with chunk

Export rows one by one to avoid memory_limit issues using yield:

Add header and rows style

Add header and rows style with headerStyle and rowsStyle methods.

Why?

FastExcel is intended at being Laravel-flavoured Spout: a simple, but elegant wrapper around Spout with the goal of simplifying imports and exports. It could be considered as a faster (and memory friendly) alternative to Laravel Excel, with less features. Use it only for 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.

Still, remember that Laravel Excel has many more features.