Printing examples

Printing Excel examples, explained clearly.

Open a focused example to see the implementation path, copy-ready PHP, expected workbook behavior, and the production boundary that matters.

Open first example View all 92 examples

2examples in this category

21focused categories

5implementation paths

Print Area

Define the print area in an Excel template and preserve its worksheet settings while replacing the data.

EasyTrusted template

preserveAdvancedObjectsFrom()

<?php

use Mnb\PHPExcel\MnbExcel;

MnbExcel::report($rows)
    ->withHeader()
    ->preserveAdvancedObjectsFrom('templates/a4-print-area.xlsx')
    ->save('print-ready-report.xlsx');

Page Layout

Preserve orientation, paper size, margins, scaling, headers, and footers from a print-ready template.

EasyTrusted template

title()preserveAdvancedObjectsFrom()

<?php

use Mnb\PHPExcel\MnbExcel;

MnbExcel::report($rows)
    ->title('Quarterly Operations Report')
    ->withHeader()
    ->preserveAdvancedObjectsFrom('templates/landscape-page-layout.xlsx')
    ->save('quarterly-operations-print.xlsx');

Was this guide useful?Use GitHub issues for corrections, missing examples, or unclear behavior.

Open an issue