Handy php-excel wrapper classes

1.0.4 2017-01-22 10:51 UTC


Build Status

API for simplified PhpExcel navigation and generating reports.


Right now this stuff works only under *nix systems.

If you want i.e. fill excel template with data and send it to output or save locally it is for you. Navigator classes take PhpExcel cell selection into cartesian like coordinates.


If you don’t have Composer yet, you should get it now.

  1. Add the package to your composer.json:

     "require": {
       "aaugustyniak/phpexcelhandler": "1.0.0",
  2. Install:

     $ php composer.phar install
  3. And use:

require_once "vendor/autoload.php";

$data = array(
            array("Column1", "Column2", "Column3"),
            array(1001, 2001, 3001),
            array(4001, 5001, 6001),
            array(7001, 8001, 9001),

$phpExcelFactory = new DefaultPhpExcelFactory();
$spreadSheet = new SpreadSheet($phpExcelFactory);

$anchorGuesser = new WriteAnchorGuesser($data);

$writer = new WriteTabularCommand($anchorGuesser);
$outputHtml = $spreadSheet->getHtmlStream();
echo $outputHtml;