Download the PHP package cyber-duck/laravel-excel without Composer
On this page you can find all versions of the php package cyber-duck/laravel-excel. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
FAQ
Example:
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 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.
Informations about the package laravel-excel
Laravel Excel
Exporting and importing Excel, CSV and OpenOffice stylesheets using Eloquent Collections and Query Builders in Laravel (5. and 4.).
It's based on box/spout.
Author: Simone Todaro
Contributors: Clément Blanco
Made with :heart: by Cyber-Duck Ltd
Installation
Export Excel
Import Excel
Different formats
Installation
Use composer to download the package:
Laravel 4.x
Register the service provider in config/app.php by adding this line to providers array.
Laravel < 5.5
Register the service provider in config/app.php by adding this line to providers array.
Laravel > 5.5
No need to register anything, since it used package auto discovery feature in Laravel 5.5.
Export Excel
Generate and download an excel file
Add
to your controller.
In your controler function, create a new excel file from an Eloquent collection.
The exporter class is fluent, so you can also write
The exporter class supports Query builder objects as well
If you deal with big tables, you can set the chunk size to minimise the memory usage
Generate and save an excel file
To save the excel file on the server, use the save method.
Advanced usage
By default, every element of the Collection becomes a row and every unprotected field of the Model becomes a cell.
No headers row is printed.
To change this behaviour, create a class extending Cyberduck\LaravelExcel\Contract\SerialiserInterface, implement the methods getHeaderRow() and getData(Model $data) and set this class on the excel object usint setSerialiser().
getHeaderRow() must return an array of string where every element is a cell of the first row. To not print the header row, simply return a void array [].
getData(Model $data) must return an array of string, and every elements is a cell.
Example
then set the serialiser before saving the file the collection.
Import Excel
Add
to your controller.
In your controler function, import an excel file.
The importer class is fluent, then you can also write
Advanced usage
By default, every row of the first sheet of the excel file becomes an array and the final result is wraped in a Collection (Illuminate\Support\Collection).
To import a different sheet, use setSheet($sheet)
To import each row in an Eloquent model, create a class extending Cyberduck\LaravelExcel\Contract\ParserInterface and implement the methods transform($row).
Example
then set the parser before creating the collection.
Different formats
The package supports ODS and CSV files.
ODS
CSV
All versions of laravel-excel with dependencies
box/spout Version ^3.1
illuminate/database Version ^6.0.0|^7.0.0|^8.0.0
illuminate/support Version ^6.0.0|^7.0.0|^8.0.0