Tuesday, January 4, 2011

Re: export to excle

hi all,

       till now i try to genarate reports and export to excel by rendering the genarated report

     by calling layout  $this->layout = 'export_xls'; and then export my report

    $this->render('buyersearchxls','export_xls');

    and the lay out export_xls contais the falloing
 
    <?php
 
header ("Expires: Mon, 28 Oct 2008 05:00:00 GMT");
header ("Last-Modified: " . gmdate("D,d M YH:i:s") . " GMT");
header ("Cache-Control: no-cache, must-revalidate");
header ("Pragma: no-cache");
header ("Content-type: application/vnd.ms-excel");
//header ("Content-Type: application/x-msexcel");
header ("Content-Disposition: attachment; filename=\"Report.xls" );
header ("Content-Description: Generated Report" );
//header("Content-Transfer-Encoding: binary "); 
?>
<?php echo $content_for_layout ?>

<?php //print $content_for_layout; ?>

but my client is experting to genarate binary xls files can any one plese clarify me whst is dif b/w xls file and binery xls

file and how can i achive it in cakephp

thanks in advance
rakesh

On Mon, Jan 3, 2011 at 12:38 PM, Ryan Schmidt <google-2010@ryandesign.com> wrote:
On Jan 3, 2011, at 01:04, rakeshyadav rakeshyadav wrote:

>        i am trying to export my report related data to excle in .xls format
>
>        i want exact result and view in both msexcel and openoffice

What have you researched on your own so far? What have you tried?

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.
 
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php?hl=en

No comments: