0

I have some spreadsheets in MS excell. Trying to convert them to PDF by using PHPOffice and mPDF class. I have a problem to create and display footers on every created PDF page

This is working code for creating a PDF from spreadsheet.

$writer = new \PhpOffice\PhpSpreadsheet\Writer\Pdf\Mpdf($pe);

Is there any solution or method i can call after this to generate footers before use save() method? Thanks in advance

Nermin Resovic
  • 1
  • 2

1 Answers1

0

You can use the footer methods e.g. generate a footer with linenumbers

$reader =  \PhpOffice\PhpSpreadsheet\IOFactory::createReader("Xlsx");

$spreadsheet = $reader->load('<path>'); //Path of reader sheet
$sheet = $spreadsheet->getActiveSheet();
$sheet->getHeaderFooter()->setFirstFooter('&C&"-,Bold"Page &P from &N'); //generate Fristfooter

There are more header/footer possibility look documentation or class documentation

Collie-IT Anne K. Frey
  • 825
  • 7
  • 19