Fix row each printed page

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?

Answers


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

Need Your Help

missing locale_t

c gtk macports osx-snow-leopard

Installing gtk 1.2 (package name gtk1) with macports chokes on the final make, in libintl.h line 440.