Print orientation using Javascript, CSS, HTML or PHP

Question

Is it possible for me to "pre-set" the orientation of the page, when the user is already printing is marked as landscape? (Landscape)

My case is the following, I’m code similar to this example

http://programacion.net/articulo/exportar_tablas_html_a_excel_con_php_y_jquery_445

I’m exporting my own HTML for Excel and in this part it is all ok, but the user does not want to lose his precious seconds configuring the page there in Excel printer properties, he wants to print the page already oriented as "landscape"(Landscape) has as using some language of those cited ?

Answer 1

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.

Answer 2

I ended up using the solution of Jasperserver with PHP has a git integration that makes this connection is very simple

an example piece:

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;
}   

Answer 3

I did in CSS once and a JS plugin called printElement.js, however it is not necessary if it is 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;
    }

}

Hence on the page that will be printed just call the CSS file with:

media='print'