tecno/wordbundle

This is a Symfony2 Bundle helps you to read and write Word files (including odt, rtf), thanks to the PHPWord library

Symfony2 Excel bundle

, _(*1)

This bundle permits you to create an easily modifiable excel object., _(*2)

Version 2

This is the shiny new version. There is a big BC with the 1.* version, but unit tests, functional tests, and the new factory is very simple to use., _(*3)

Version 1.*

If you have installed an old version, and you are happy to use it, you could find documentation and files in the tag v1.0.6, browse the code., _(*4)

Things to know:

CSV is faster so if you have to create simple xls file, I encourage you to use the built-in function for csv: http://php.net/manual-lookup.php?pattern=csv&lang=en&scope=quickref, _(*5)

Installation

1 Add to composer.json to the require key, _(*6)

``` yml "require" : { "liuggio/excelbundle": "~2.0", }, <sub>(*7)</sub>

**2** Register the bundle in ``app/AppKernel.php``

``` php
    $bundles = array(
        // ...
        new Liuggio\ExcelBundle\LiuggioExcelBundle(),
    );

TL;DR

• Create an empty object:

``` php $phpExcelObject = $this->get('phpexcel')->createPHPExcelObject();, <sub>(*8)</sub>

- Create an object from a file:

``` php
$phpExcelObject = $this->get('phpexcel')->createPHPExcelObject('file.xls');

• Create a Excel5 and write to a file given the object:

$writer = $this->get('phpexcel')->createWriter($phpExcelObject, 'Excel5');
$writer->save('file.xls');

• Create a Excel5 and create a StreamedResponse:

$writer = $this->get('phpexcel')->createWriter($phpExcelObject, 'Excel5');
$response = $writer->createStreamedResponse($writer);

Not Only 'Excel5'

The list of the types are:, <sub>(*9)</sub>

1. 'Excel5'
2. 'Excel2007'
3. 'Excel2003XML'
4. 'OOCalc'
5. 'SYLK'
6. 'Gnumeric'
7. 'HTML'
8. 'CSV'

Example

Fake Controller

The best place to start is the fake Controller at Tests/app/Controller/FakeController.php, that is a working example., <sub>(*10)</sub>

More example

You could find a lot of examples in the official PHPExcel repository https://github.com/PHPOffice/PHPExcel/tree/develop/Examples, <sub>(*11)</sub>

For lazy devs

``` php namespace YOURNAME\YOURBUNDLE\Controller;, <sub>(*12)</sub>

use Symfony\Bundle\FrameworkBundle\Controller\Controller;, <sub>(*13)</sub>

class DefaultController extends Controller {, <sub>(*14)</sub>

public function indexAction($name)
{
    // ask the service for a Excel5
   $phpExcelObject = $this->get('phpexcel')->createPHPExcelObject();

   $phpExcelObject->getProperties()->setCreator("liuggio")
       ->setLastModifiedBy("Giulio De Donato")
       ->setTitle("Office 2005 XLSX Test Document")
       ->setSubject("Office 2005 XLSX Test Document")
       ->setDescription("Test document for Office 2005 XLSX, generated using PHP classes.")
       ->setKeywords("office 2005 openxml php")
       ->setCategory("Test result file");
   $phpExcelObject->setActiveSheetIndex(0)
       ->setCellValue('A1', 'Hello')
       ->setCellValue('B2', 'world!');
   $phpExcelObject->getActiveSheet()->setTitle('Simple');
   // Set active sheet index to the first sheet, so Excel opens this as the first sheet
   $phpExcelObject->setActiveSheetIndex(0);

    // create the writer
    $writer = $this->get('phpexcel')->createWriter($phpExcelObject, 'Excel5');
    // create the response
    $response = $this->get('phpexcel')->createStreamedResponse($writer);
    // adding headers
    $response->headers->set('Content-Type', 'text/vnd.ms-excel; charset=utf-8');
    $response->headers->set('Content-Disposition', 'attachment;filename=stream-file.xls');
    $response->headers->set('Pragma', 'public');
    $response->headers->set('Cache-Control', 'maxage=1');

    return $response;        
}

} ```, <sub>(*15)</sub>

Contributors

the list of contributors, <sub>(*16)</sub>

Contribute

1. fork the project
2. clone the repo
3. get the coding standard fixer: wget http://cs.sensiolabs.org/get/php-cs-fixer.phar
4. before the PullRequest you should run the coding standard fixer with php php-cs-fixer.phar fix -v .