Member Avatar for 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");    
        ?>
  • 3 Contributors
  • 2 Replies
  • 176 Views
  • 7 Hours Discussion Span
  • Latest Post Latest Post by blocblue
Member Avatar for 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?

Member Avatar for 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.

Be a part of the DaniWeb community

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