Nico,
you have to remember that $this->renderText($text) does not return any
data but rather sfView::NONE
I think you should fix your code for clarity (although it works now)
// Save Excel 5 file
$error_reporting = error_reporting(0);
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
$xls_data = $objWriter->save();
error_reporting($error_reporting);
return $this->renderText($xls_data);
Kupo
nico_bl1nd wrote:
> thanks for your help, it works fine.
>
> finally my code looks like this :
>
> public function executeExport()
> {
> /** PHPExcel */
> include 'PHPExcel.php';
>
> /** PHPExcel_Writer_Excel5 */
> include 'PHPExcel/Writer/Excel5.php';
>
> // Create new PHPExcel object
> $objPHPExcel = new PHPExcel();
>
> // Set properties
> $objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
> $objPHPExcel->getProperties()->setLastModifiedBy("Maarten
> Balliauw");
> $objPHPExcel->getProperties()->setTitle("Office 5 XLSX Test
> Document");
> $objPHPExcel->getProperties()->setSubject("Office 5 XLSX Test
> Document");
> $objPHPExcel->getProperties()->setDescription("Test document for
> Office 5, generated using PHP classes.");
>
> // Add some data
> $objPHPExcel->setActiveSheetIndex(0);
> $objPHPExcel->getActiveSheet()->SetCellValue('A1', 'Hello');
> $objPHPExcel->getActiveSheet()->SetCellValue('B2', 'world!');
> $objPHPExcel->getActiveSheet()->SetCellValue('C1', 'Hello');
> $objPHPExcel->getActiveSheet()->SetCellValue('D2', 'world!');
>
> // Rename sheet
> $objPHPExcel->getActiveSheet()->setTitle('Simple');
>
> $this->getResponse()->clearHttpHeaders();
> $this->getResponse()->setHttpHeader('Content-Type', 'application/
> vnd.ms-excel');
> $this->getResponse()->setHttpHeader('Content-Disposition:',
> 'attachment; filename=export12.xls');
>
> // Save Excel 5 file
> $error_reporting = error_reporting(0);
> $objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
> $xls_data = $this->renderText($objWriter->save());
> error_reporting($error_reporting);
>
> return $xls_data;
> }
>
>
> >
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"symfony users" group.
To post to this group, send email to symfony-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/symfony-users?hl=en
-~----------~----~----~----~------~----~------~--~---
