CakePHP excel generator

v1.0.5 2014-02-06 10:13 UTC


Coverage Status Build Status

A plugin to generate Excel files with CakePHP.


  • PHP 5.2.8
  • CakePHP 2.1+
  • PHPExcel
  • Composer


Add to your composer.json file (dakota/cake-excel)

"dakota/cake-excel": ">=1.0"

Or run

composer require "dakota/cake-excel >=1.0"


In app/Config/bootstrap.php add:

CakePlugin::load('CakeExcel', array('bootstrap' => true, 'routes' => true));

Add the RequestHandler component to AppController, and map xlsx to the CakeExcel plugin

'RequestHandler' => array(
    'viewClassMap' => array(
        'xlsx' => 'CakeExcel.Excel'

Create a link to the a action with the .xlsx extension

$this->Html->link('Excel file', array('ext' => 'xlsx'));

Place the view templates in a 'Excel' subdir, for instance app/View/Invoices/Excel/index.ctp

Inside your view file you will have access to the PHPExcel library with $this->PhpExcel. Please see the PHPExcel documentation for a guide on how to use PHPExcel.