How can PHP Spreadsheet be used to add header and footer to a document?

To add a header and footer to a document using PHP Spreadsheet, you can use the `HeaderFooter` class to set the desired header and footer content. You can then apply the header and footer to the active sheet using the `setHeader` and `setFooter` methods. 

use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Worksheet\HeaderFooter;

$spreadsheet = new Spreadsheet();
$sheet = $spreadsheet->getActiveSheet();

$headerFooter = $sheet->getHeaderFooter();
$headerFooter->setOddHeader('&C&"Arial,Regular"Header Text');
$headerFooter->setOddFooter('&L&B' . $spreadsheet->getProperties()->getTitle() . '&RPage &P of &N');

$sheet->setHeader($headerFooter->getOddHeader());
$sheet->setFooter($headerFooter->getOddFooter());

Keywords

PHP Spreadsheet header footer document

Related Questions