Hi,
I am saying use the code in the action of a module. Please let me know if
you understand action of a module.
public function executeFiledownload($request)
{
// Create new PHPExcel object
$objPHPExcel = new sfPhpExcel();
// Set active sheet index to the first sheet, so Excel opens this as the
first sheet
$objPHPExcel->setActiveSheetIndex(0);
// Set properties
$objPHPExcel->getProperties()->setCreator("Maarten Balliauw");
$objPHPExcel->getProperties()->setLastModifiedBy("Maarten Balliauw");
$objPHPExcel->getProperties()->setTitle("Office 2007 XLSX Test
Document");
$objPHPExcel->getProperties()->setSubject("Office 2007 XLSX Test
Document");
$objPHPExcel->getProperties()->setDescription("Test document for Office
2007 XLSX, generated using PHP classes.");
$objPHPExcel->getProperties()->setKeywords("office 2007 openxml php");
$objPHPExcel->getProperties()->setCategory("Test result file");
// Set default font
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setName('Arial');
$objPHPExcel->getActiveSheet()->getDefaultStyle()->getFont()->setSize(12);
$objPHPExcel->getActiveSheet()->getColumnDimension('A')->setWidth(6);
$objPHPExcel->getActiveSheet()->getColumnDimension('B')->setWidth(25);
$objPHPExcel->getActiveSheet()->getColumnDimension('C')->setWidth(22);
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(13);
$objPHPExcel->getActiveSheet()->getColumnDimension('E')->setWidth(12);
// Save Excel 2007 file
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcel);
$todaydate = date("d-m-y");
$todaydate = $todaydate.'-'.date("H-i-s");
$filename = 'Reports';
$filename = $filename.'-'.$todaydate;
$filename = $filename.'.xls';
$filename = '/var/tmp/'.$filename;
$objWriter->save($filename);
}
On Tue, Apr 20, 2010 at 1:34 AM, safa boubekri <[email protected]>wrote:
> i do it symfony cc
>
> but the same msg
>
> --
> If you want to report a vulnerability issue on symfony, please send it to
> security at symfony-project.com
>
> You received this message because you are subscribed to the Google
> Groups "symfony users" group.
> To post to this group, send email to [email protected]
> To unsubscribe from this group, send email to
> [email protected]<symfony-users%[email protected]>
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=en
>
--
If you want to report a vulnerability issue on symfony, please send it to
security at symfony-project.com
You received this message because you are subscribed to the Google
Groups "symfony users" group.
To post to this group, send email to [email protected]
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
