Download the PHP package mohammed-zaki/laravel-excel without Composer
On this page you can find all versions of the php package mohammed-zaki/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.).
With multiple Sheets support
It's based on box/spout.
Author: Simone Todaro
Contributors: Clément Blanco, Cyber-Duck Ltd
Made with :heart: by Mohammed Zaki
Installation
Export Excel
Export Excel with multiple sheets
Import Excel
Different formats
Installation
Use composer to download the package:
Register the service provider in config/app.php adding CyberduckWithSheets\LaravelExcel\ExcelServiceProvider to the provider array.
Note. If you are on Laravel 4, use CyberduckWithSheets\LaravelExcel\ExcelLegacyServiceProvider
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
Export Excel with multiple sheets
The exporter class supports Multiple Sheets as follow
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 CyberduckWithSheets\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
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 CyberduckWithSheets\LaravelExcel\Contract\ParserInterface and implement the methods transform($row).
Example
Different formats
The package supports ODS and CSV files.
ODS
CSV
All versions of laravel-excel with dependencies
box/spout Version ^2.4
illuminate/database Version 4.*|5.*
illuminate/support Version 4.*|5.*