PhpExcel helper and component for CakePHP 2.x

PHPExcel is a great library that can create XLS files. For more information see PHPExcel project homepage.

I added method for setting font and for easy table data adding. Short example:

// create new empty worksheet and set default font
$this->PhpExcel->createWorksheet()
    ->setDefaultFont('Calibri', 12);

// define table cells
$table = array(
    array('label' => __('User'), 'filter' => true),
    array('label' => __('Type'), 'filter' => true),
    array('label' => __('Date')),
    array('label' => __('Description'), 'width' => 50, 'wrap' => true),
    array('label' => __('Modified'))
);

// add heading with different font and bold text
$this->PhpExcel->addTableHeader($table, array('name' => 'Cambria', 'bold' => true));

// add data
foreach ($data as $d) {
    $this->PhpExcel->addTableRow(array(
        $d['User']['name'],
        $d['Type']['name'],
        $d['User']['date'],
        $d['User']['description'],
        $d['User']['modified']
    ));
}

// close table and output
$this->PhpExcel->addTableFooter()
    ->output();