flowcode / excel-service-provider
An Excel ServiceProvider for Silex.
Requires
- nercury/symfony2-stream-response: 1.0
- phpoffice/phpexcel: 1.8.0
- silex/silex: ~1.1
This package is not auto-updated.
Last update: 2024-10-08 16:01:09 UTC
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;