An Excel ServiceProvider for Silex version 2.
This package is forked from https://github.com/Jaza/ExcelServiceProvider
1 Add to the 'require' section of composer.json:
"require" : {
"igor822/excel-service-provider": "1.0.*@dev",
}
2 Register the provider:
$app->register(new Jaza\Silex\ExcelServiceProvider());
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;