flowcode/excel-service-provider

An Excel ServiceProvider for Silex.

dev-master / 1.0.x-dev 2014-11-22 23:53 UTC

Requires

• nercury/symfony2-stream-response: 1.0
• phpoffice/phpexcel: 1.8.0
• silex/silex: ~1.1

MIT

• Jeremy Epstein

• silex

README

An Excel ServiceProvider for Silex.

This package is based on https://github.com/liuggio/ExcelBundle - many parts of the code are copied directly from there. This package implements the PHPExcel integration as a Silex Service Provider, instead of as a Symfony2 component.

I've only implemented Excel5 support, and I doubt that I will implement the other export formats offered by the liuggio version, because I simply don't need them myself. Feel free to fork or to submit patches if you're keen to implement the other formats.

Installation

1 Add to the 'require' section of composer.json:

    "require" : {
        "jaza/excel-service-provider": "1.0.*@dev",
    }

2 Register the provider:

$app->register(new Jaza\Silex\ExcelServiceProvider());

Usage

From within a Silex callback or elsewhere:

$excelService = $app['xls.service_xls5'];

$excelService->excelObj->getProperties()->setCreator("Me")
                       ->setLastModifiedBy("Me")
                       ->setTitle("Test Document")
                       ->setSubject("Test Document")
                       ->setDescription("Testing a document.")
                       ->setKeywords("testdoc")
                       ->setCategory("Test doc");
    
$excelService->excelObj->setActiveSheetIndex(0)
             ->setCellValue('A1', 'Hello')
             ->setCellValue('B2', 'world!');

$excelService->excelObj->getActiveSheet()->setTitle('Simple');
$excelService->excelObj->setActiveSheetIndex(0);

$response = $excelService->getResponse();
$response->headers->set('Content-Type', 'text/vnd.ms-excel; charset=utf-8');
$response->headers->set('Content-Disposition', 'attachment;filename=test.xls');

// If you are using a https connection, you have to set those two headers for compatibility with IE <9
$response->headers->set('Pragma', 'public');
$response->headers->set('Cache-Control', 'maxage=1');

return $response;