Hi Cricket
Did you manage to have records opening in different tabs?
On Thursday, 25 November 2010 18:08:47 UTC+2, the plumpNation wrote:
>
> Hi guys,
>
> I have a sales report in excel which is generated using cakephp and
> PHPExcel. I am very happy with both of these frameworks/libraries. I
> am really starting to feel very comfortable using them both and am
> finally getting to the stage of being able to 'rapidly develop', the
> whole point of cake.
>
> Currently, the sales are generated from customers who share
> distributors. So the logic goes
>
> foreach(distributor){
> // create excel of sales using this distributor;
> // send email with sales to this distributor;
> }
>
> Then I added functionality to allow the sales manager to download the
> sheet just to check it, before the cron ran and sent it to the
> distributors.
>
> foreach(distributor){
> // create excel of sales using this distributor;
> if(!browserOutput){
> // send email with sales to this distributor;
> }else{
> // output the excel sheet to the browser;
> }
> }
>
> Now it all works fine except that I only receive the first sheet,
> probably because you can't do a looping download. I was just wondering
> if anyone had an elegant solution to this that didn't involve me
> writing the sheets to different tabs in the same excel sheet, but
> allows the manager to receive all the sheets from the browser one at a
> time. Maybe opening the output in different tabs or windows might
> work, but not sure how to do this. At the moment I set headers to the
> correct mime type like so
>
> if($browserOutput){
>
> $message .= 'for output to browser<br />';
> header( 'Content-Type:
> application/vnd.ms-excel' );
> header( 'Content-Disposition:
> attachment;filename="' . $filename .
> '"');
> header( 'Cache-Control: max-age=0' );
>
> }
>
> and then use PHPExcel like so
>
> $thisSheet->save('php://output');
>
> Whatcha fink? Is this possible or should I write all the sheets into
> one file to download?
>
> Cheers for reading
--
Like Us on FaceBook https://www.facebook.com/CakePHP
Find us on Twitter http://twitter.com/CakePHP
---
You received this message because you are subscribed to the Google Groups
"CakePHP" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/cake-php?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
