PHP download

Download the PHP package syspons/laravel-sheetable without Composer

On this page you can find all versions of the php package syspons/laravel-sheetable. 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?

Example code of syspons/laravel-sheetable

Informations about the package laravel-sheetable

Laravel-Sheetable

A helper for importing and exporting Eloquent models.

Easily add import + export routes + controllers by adding a Trait to your model.

This package utilizes laravel-excel which is a wrapper around PhpSpreadsheet

Installation

Concept

The package provides an interface to the database using excel import and export. It can be used to create or update entities, not to delete them. For updating a unique identifier in the table is necessary.

Dropdownable

Plain data from the table will be shown in the export as is. However, there might be relations within the data, that shall be shown inside the export (or import). These are defined by DropdownConfigs. These represent a relation within the excel. It is possible to include one to many and many to many relationships. For every relation you'll find a dropdown in your excel to select one of the related entities. There will be a workbook inside your spreadsheet that contains all related models, mapped to their key, in order to make it possible to import these relations as well.

Join

If you want more, than a single column of a relation joined to your export table, you will need to use the Join functionality. You have the possibility to add nested joins and to select any column of the joined table.

Usage

Create your table and corresponding model, eg. with php artisan make:model YourModel -m
Implement the Sheetable interface in your newly generated model.
The package will register the following routes:
- Export, get, post yourmodels/export => export all desired entities
- Template, get yourmodels/template => export an empty spreadsheet
- Import, post yourmodels/import => import a spreadsheet

Options

To change the default options use

Inherited from laravel-targetable
- namespace: String or array with one ore multiple namespaces that should be monitored for the configured trait. Defaults to App\Models.
- namespace_mode: Defines the search mode for the namespaces. ClassFinder::STANDARD_MODE will only find the exact matching namespace, ClassFinder::RECURSIVE_MODE will find all subnamespaces. Defaults to ClassFinder::STANDARD_MODE.
- prefix: Defines the route prefix. Defaults to api.
Formats
- export_format: Defines the export format. Possible values are: XLSX, CSV, TSV, ODS, XLS, HTML, MPDF, DOMPDF, TCPDF. See the Laravel-Excel Documentation. Defaults to XLSX.
- import_format: Defines the import format. Possible values are: XLSX, CSV, TSV, ODS, XLS, SLK, XML, GNUMERIC, HTML. See the Laravel-Excel Documentation. Defaults to ANY.

Architecture

The package relies on laravel-targetable to connect specific functionality to Laravel model entities via contracts. (Sheetable, Dropdownable).
The entrypoints to all functionality is provided by the SheetController by utilizing laravel-excel.
- SheetsExport is used to provide export + template functionality.
- SheetImport is used to provide import functionality.
- Both rely on SpreadsheetHelper and SpreadsheetUtils for core functionality.
ExportRequest implements the rules for selecting entities or columns to export
The SpreadsheetDropdowns helper implements all functionality connected to relations / Dropdownables.
SpreadsheetJoins and Join gather the join functionality.

Compatibility

Tested with Laravel 10.x.

License

All versions of laravel-sheetable with dependencies

PHP Build Version

Package Version

Version 2.1.4 Release 16. Nov 2023
create-project require 0 people choosed require and
0 people choosed create-project.

Download

Download latest version of laravel-sheetable from vendor syspons

Requires berthott/laravel-scopeable Version ^2.0.0
haydenpierce/class-finder Version ^0.4.3
barryvdh/laravel-ide-helper Version 2.12.3
maatwebsite/excel Version ^3.0

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package syspons/laravel-sheetable contains the following files

Loading the files please wait ....