Set rows to repeat at top when printing - PHPExcel

问题:

I need to put table head row to each printed page while printing a long data sheet(like this), but I failed to find any related setup in PHPExcel, could anyone faced the same problem help me out?

回答1:

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

This worked for me