Installation

Step 1: Download the Bundle

Open a command console, enter your project directory and execute the following command to download the latest stable version of this bundle:

$ composer require mewesk/twig-excel-bundle

Or add the following code to your composer.json file and run composer update afterwards:

{
    "require": {
        "mewesk/twig-excel-bundle": "1.3.*@dev"
    }
}

$ php composer.phar update mewesk/twig-excel-bundle

This requires you to have Composer installed globally, as explained in the [installation chapter](https://getcomposer.org/doc/00-intro.md) of the Composer documentation.

Step 2: Enable the Bundle

<?php
// app/AppKernel.php

// ...
class AppKernel extends Kernel
{
    public function registerBundles()
    {
        $bundles = array(
            // ...

            new MewesK\TwigExcelBundle\MewesKTwigExcelBundle(),
        );

        // ...
    }

    // ...
}

Step 3: Configure the Bundle (optional)

Add the following configuration to your config.yml if you don’t want to pre-calculate formulas. Disabling this option can improve the performance but the resulting documents won’t show the result of any formulas when opened in a external spreadsheet software.

mewes_k_twig_excel:
    pre_calculate_formulas: false

Add the following configuration to your config.yml if you want to enable disk caching. Using disk caching can improve memory consumption by writing data to disk temporarily. Works only for .XLSX and .ODS documents.

mewes_k_twig_excel:
    disk_caching_directory: "%kernel.cache.dir%/phpexcel"