PHP TO EXCEL

[ecinevenice]

hey does anyone here knows how to change excel page orientation to portrait? i get landscape as default

 <?php 
        header("Content-type: application/vnd.ms-excel");
        header("Content-Disposition: attachment; filename=transactions.xls");
        header("Pragma: no-cache");
        header("Expires: 0");    
        ?>

[minitauros]

I didn't even know there was anything like an oriental or portrait lay-out in Excel, just thought that depended on the width of your cells :o?

[blocblue]

You would need to set the worksheet orientation through whatever Excel library you're using, not through the response headers.

PEAR and PHP Excel are two such libraries, both which support page orientation.