Fix row each printed page

Question

I need to configure one or more rows as header or footer to be printed on each page. I don't know the numbers of pages to print, it's dynamic.

Can I set several rows (or one) to be printed on each page using PHPExcel library?

Answer 1

From the PHPExcel documentation:

$objPHPExcel->getActiveSheet()
    ->getPageSetup()
    ->setRowsToRepeatAtTopByStartAndEnd(1, 5);

Or if you want to use Headers/Footers that aren't spreadsheet rows, but part of the page setup, then (again from the PHPExcel documentation).... useful for page numbering

$objPHPExcel->getActiveSheet()
    ->getHeaderFooter()
    ->setOddFooter('&L&B' . $objPHPExcel->getProperties()->getTitle() . '&RPage &P of &N');