Download the PHP package simtecsystem/cakephp-excel without Composer

On this page you can find all versions of the php package simtecsystem/cakephp-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?

Example code of simtecsystem/cakephp-excel

Informations about the package cakephp-excel

CakePHP Excel plugin

Latest Stable Version Total Downloads Build Status codecov

CakePHP Excel plugin allows for spreadsheet files manipulation with the power of CakePHP ORM. This plugin is build using PHPSpreadsheet library and can work with multiple types of spreadsheet files (excel, csv etc).

NOTE: CakePHP Excel plugin versions 0.4.0 and lower used now abandoned PHPExcel library.

Installation

CakePHP 3.6+

CakePHP 3.5 and lower:

Using the plugin

Excel plugin lets you manipulate spreadsheet files multiple ways. The simplest use case is to load your spreadhseet data into CakePHP ORM table.

For example we are loading an excel file that contains some record data.

A B C
1 Led Zeppelin Led Zeppelin II 1969
2 Deep Purple Machine Head 1972
3 Pink Floyd Wish You Were Here 1975

Spreadsheet data is now loaded into CakePHP ORM table.

Each column is represented as a property. Values are string by default.

You may also map columns to custom properties and types.

Spreadsheet data is now loaded into CakePHP ORM with custom properties and types.

You may want to manipulate some data and write it back to excel file. This is also possible.

Now the new record is saved, but excel file has not been updated yet. You have to call writeSpreadsheet() method:

You may also want to read or write only some of the rows and columns.

Note that _row does not match the real row index. To keep original row indexes you must use keepOriginalRows option.

The same principle applies to writing to a file. If you delete the second row it won't become empty in result excel file when keepOriginalRows is false. You have to set this option to true if you want to keep rows consistency across the table and the file.

Behavior

This plugin provides a behavior which could be added to any table.

If you want to load data into your table you have to set a worksheet instance.

Now your table is populated with excel data.

If you want to write your data back to excel file you have to set a file.

Working with different tables

It is also possible to load data into any table.

All versions of cakephp-excel with dependencies

PHP Build Version
Package Version
Requires php Version >=5.6
cakephp/filesystem Version ^3.4
cakephp/orm Version ^3.4
phpoffice/phpspreadsheet Version ^1.1
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 simtecsystem/cakephp-excel contains the following files

Loading the files please wait ....