Print orientation using JavaScript, CSS, HTML or PHP

If the server platform is Windows. What you can do is create a macro in VBS to do this. Create the file: worksheet.vbs

$file = 'seu_arquivo.xls';
$path = "C:\temp\";
$fp = fopen($path.'worksheet.vbs', 'w');

$content = '
 Sub setUpPage(sheet) 
       With Workbooks("'.$file.'")
          .Sheets (sheet).PageSetup
          .Orientation = xlLandscape 
          .PaperSize = xlPaperA4 
          .Zoom = False
          .FitToPagesWide = 1 
          .FitToPagesTall = False 
       End With 
     End Sub 
';

fwrite($fp, $content);
fclose($fp);

Or without passing file, create without writing:

Sub Macro()
    With ActiveSheet.PageSetup
        .Orientation = xlLandscape
    End With
End Sub

And in PHP, run it:

if (file_exists("{$path}worksheet.vbs")) {
    $WshShell = new COM("WScript.Shell");
    $obj = $WshShell->Run("cscript {$path}worksheet.vbs", 0, true); 
}

Here has more information.

I ended up using the JasperServer solution with PHP integration in git that makes this connection is very simple

An example snippet:

try {
    $jasper = new Adl\Integration\RequestJasper();
    /*
    To send output to browser
    */
    header('Content-type: application/pdf');
    echo $jasper->run('/reports/samples/AllAccounts');

    /*
    To Save content to a file in the disk
    The path where the file will be saved is registered into config/data.ini
    */
    //$jasper->run('/reports/samples/AllAccounts','PDF', null, true);

} catch (\Exception $e) {
    echo $e->getMessage();
    die;
}   

I've done this in CSS once and a JS plugin called printElement.js , but it's not necessary if it's a simple page.

Print Element

CSS

@media print{

    @page{
        size: landscape;
    }

    #image-example{
        position: absolute;
        top: 0;
        bottom: 0;
        left: 0;
        right: 0;
        margin: auto;
    }

}

From the page that will be printed, just call the CSS file with:

media='print'