Download the PHP package rap2hpoutre/fast-excel without Composer

On this page you can find all versions of the php package rap2hpoutre/fast-excel. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Please rate this library. Is it a good library?

All versions of fast-excel with dependencies

Informations about the package fast-excel

Version License Build Status Scrutinizer Code Quality Codacy Badge Total Downloads

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.

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 has many more features.


Version
Requires php Version ^7.1|^8.0
illuminate/support Version 5.3.* || 5.4.* || 5.5.* || 5.6.* || 5.7.* || 5.8.* || ^6.0 || ^7.0 || ^8.0
box/spout Version ^3

The package rap2hpoutre/fast-excel contains the following files

Loading the files please wait ....