Download the PHP package lunia-consultores/laravel-excel without Composer
On this page you can find all versions of the php package lunia-consultores/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 10 Excel
Fork from legacy Maatwebsite/Laravel-Excel to support Laravel 10
Installation
Require this package with composer using the following command:
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 ^10.0.0
illuminate/support Version ^10.0.0