fml/phpsimpleexcel

PHPSimpleExcel is a library basing on oliverschwarz/php-excel

FunkyMonkeyLabs\PHPSimpleExcel by FunkyMonkeyLabs

PHPSimpleExcel is a library basing on oliverschwarz/php-excel. This implementation allow to you to controlling current row by startRow() method, which returns Row object., _(*1)

Instalation

FunkyMonkeyLabs\PHPSimpleExcel is available on packagist.org (composer), so you can simply add:, _(*2)

    "require": {
        "fml/phpsimpleexcel" : "v1.0.0"
    }

Usage

<?php

require_once __DIR__.'/vendor/autoload.php';

$excel = new FML\PhpSimpleExcel\PhpSimpleExcel();
$excel->addNamedStyle('idFormat', array(
        "NumberFormat" => array(
            "ss:Format" => "##00"
        )
    ));
$excel->addRow(array(
        "id", "Column1", "Column2"
    ));

foreach(range(0,11) as $id) {
    $excel
        ->startRow()
        ->addCell($id, 'Number', 'idFormat')
        ->addCell('value'.$id)
        ->addCell('value2'.$id)
        ->end();
}
echo $excel->generateXML('excel');