Multiple excel sheet download

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

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