Download the PHP package queencitycodefactory/cakespreadsheet without Composer
On this page you can find all versions of the php package queencitycodefactory/cakespreadsheet. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download queencitycodefactory/cakespreadsheet
More information about queencitycodefactory/cakespreadsheet
Files in queencitycodefactory/cakespreadsheet
Package cakespreadsheet
Short Description CakePHP 3 PHP Spreadsheet
License MIT
Homepage https://github.com/QueenCityCodeFactory/CakeSpreadsheet.git
Informations about the package cakespreadsheet
CakeSpreadsheet
CakeSpreadsheet is a CakePHP 3.x plugin for generating Excel Files in the xlsx format using PHPOffice/PhpSpreadsheet.
Requirements
- CakePHP 3.x
- PHP 7.2
Installation
[Using Composer]
Enable plugin
Load the plugin in your app's config/bootstrap.php
file:
Usage
First, you'll want to setup extension parsing for the xlsx
extension. To do so, you will need to add the following to your config/routes.php
file:
Next, we'll need to add a viewClassMap entry to your Controller. You can place the following in your AppController:
Each application must have an xlsx layout. The following is a simple layout that can be placed in src/Template/Layout/xlsx/default.ctp
:
Finally, you can link to the current page with the .xlsx extension. This assumes you've created an xlsx/index.ctp
file in your particular controller's template directory:
Inside your view file you will have access to the PhpOffice\PhpSpreadsheet\Spreadsheet
library by using $spreadsheet = $this->getSpreadsheet()
. Please see the PhpOffice\PhpSpreadsheet documentation for a guide on how to use PhpOffice\PhpSpreadsheet
.
All versions of cakespreadsheet with dependencies
cakephp/cakephp Version ^3.5.10
phpoffice/phpspreadsheet Version ^1.6.0