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?
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');