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");    
        ?>

Recommended Answers

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?

Jump to Post

All 2 Replies

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?

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.