Symfony2 having an issue with phpexcel and service_xls5

Question

Symfony2 having problem with $excelService = $this->get('xls.service_xls5');

The problem shown is

You have requested a non-existent service "xls.service_xls5".
500 Internal Server Error - ServiceNotFoundException

Any idea how to solve this?

By the way, this is my composer.json

"require": {
    "php": ">=5.3.3",
    "symfony/symfony": "2.3.*",
    "doctrine/orm": ">=2.2.3,<2.4-dev",
    "doctrine/doctrine-bundle": "1.2.*",
    "twig/extensions": "1.0.*",
    "symfony/assetic-bundle": "2.3.*",
    "symfony/swiftmailer-bundle": "2.3.*",
    "symfony/monolog-bundle": "2.3.*",
    "sensio/distribution-bundle": "2.3.*",
    "sensio/framework-extra-bundle": "2.3.*",
    "sensio/generator-bundle": "2.3.*",
    "incenteev/composer-parameter-handler": "~2.0",
    "apy/datagrid-bundle": "dev-master",
    "friendsofsymfony/user-bundle": "~2.0@dev",
    "liuggio/excelbundle": ">=1.0.4",
    "mbence/opentbs-bundle": "dev-master",
    "phpoffice/phpexcel": "dev-master"
}

But I can't install phpoffice/phpexcel that has been my last try..

---

Modification on 25/06/2014

After the help of Splendonia, I was able to install/update in a correct way my luiggioBundle and realize that now It has a new API. Then I ran the example that is in LuiggioBundle in Github documentation and all worked just fine.

namespace YOURNAME\YOURBUNDLE\Controller;

use Symfony\Bundle\FrameworkBundle\Controller\Controller;

class DefaultController extends Controller
{

    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;        
    }
}

Answer 1

First, When you're adding "liuggio/excelbundle": ">=1.0.4", to your composer.json, it should automatically dowload dependencies when you run composer install or composer update. In my case, my composer.json has this:

"require": {
        "php": ">=5.3.3",
        "symfony/symfony": "2.3.*",
        "doctrine/orm": ">=2.2.3,<2.4-dev",
        "doctrine/doctrine-bundle": "1.2.*",
        "twig/extensions": "1.0.*",
        "symfony/assetic-bundle": "2.3.*",
        "symfony/swiftmailer-bundle": "2.3.*",
        "symfony/monolog-bundle": "2.3.*",
        "sensio/distribution-bundle": "2.3.*",
        "sensio/framework-extra-bundle": "2.3.*",
        "sensio/generator-bundle": "2.3.*",
        "incenteev/composer-parameter-handler": "~2.0",
        "liuggio/excelbundle": "~2.0"
    }

always, after adding new bundles to your composer.json, you should run composer update to add the new dependencies, doing this:

php composer.phar update

After the process is completed, you need to register the bundle in app/AppKernel.php file like this...

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

Note: in my case I need to open a file so, In my Controller I need to add use PHPExcel_IOFactory; at the beginning.

$readerObject = PHPExcel_IOFactory::createReader('Excel5');
$phpExcelObject = $readerObject->load('path/to/file. '.xls');

To write new excel files do:

$phpExcelObject = $this->get('phpexcel')->createPHPExcelObject();
$phpExcelObject->getProperties()->setCreator('Me')
                                    ->setLastModifiedBy('Me')
                                    ->setTitle("General Overview");
$phpExcelObject->createSheet(0);
$phpExcelObject->setActiveSheetIndex(0);
$phpExcelObject->getActiveSheet()->setTitle('General Overview');
$phpExcelObject->setActiveSheetIndex(0)->setCellValue('A1', 'Title');
$writer = $this->get('phpexcel')->createWriter($phpExcelObject, 'Excel5');
$writer->save('files/report.xls');

I think your issue might be not installing properly the bundle, or registering in your AppKernel.php. This should work just fine.