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.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

All versions of fast-excel with dependencies

Informations about the package fast-excel

Version License StyleCI Tests 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:

Import multiple sheets with sheets names:

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.3 || ^8.0
illuminate/support Version 5.3.* || 5.4.* || 5.5.* || 5.6.* || 5.7.* || 5.8.* || ^6.0 || ^7.0 || ^8.0 || ^9.0
openspout/openspout Version ^3

The package rap2hpoutre/fast-excel contains the following files

Loading the files please wait ....