求大神PHPEXCEl 如何设置打印标题及页眉

Question

求大神PHPEXCEl 如何设置打印标题及页眉
输出2007格式，求大神帮忙

Answer 1

$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&C&HPlease treat this document as confidential!');  //页眉
$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&L&B' . $objPHPExcel->getProperties()->getTitle() . '&RPage &P of &N');  //页脚标题 是指什么？

Answer 2

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