aaugustyniak/phpexcelhandler

Handy php-excel wrapper classes

, _(*1)

API for simplified PhpExcel navigation and generating reports.

PhpExcelHandler

Right now this stuff works only under *nix systems., _(*2)

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., _(*3)

Installation

If you don’t have Composer yet, you should get it now., _(*4)

1. Add the package to your composer.json:, _(*5)

   "require": {
     ...
     "aaugustyniak/phpexcelhandler": "1.0.0",
     ...
   }

2. Install:, _(*6)

   $ php composer.phar install

3. And use:, _(*7)

```php require_once "vendor/autoload.php";, <sub>(*8)</sub>

$data = array( array("Column1", "Column2", "Column3"), array(1001, 2001, 3001), array(4001, 5001, 6001), array(7001, 8001, 9001), );, <sub>(*9)</sub>

$phpExcelFactory = new DefaultPhpExcelFactory(); $spreadSheet = new SpreadSheet($phpExcelFactory);, <sub>(*10)</sub>

$anchorGuesser = new WriteAnchorGuesser($data);, <sub>(*11)</sub>

$writer = new WriteTabularCommand($anchorGuesser); $spreadSheet->modify($writer); $outputHtml = $spreadSheet->getHtmlStream(); echo $outputHtml;, <sub>(*12)</sub>