How to show header?

Topics: Developer Forum, User Forum
Oct 8, 2010 at 12:23 PM

Hi,

I already know how to write a header using this command:

$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddHeader('&CThis is a header');

But when the sheet is downloaded and opened the header is not visible, I have to change the sheet exhibition to "Page layout" manually.

Is there a way to change the exhibition to "Page layout" using PHPExcel??

Thanks.

Ricardo

Coordinator
Oct 11, 2010 at 8:46 PM

No! I don't know if Excel supports automatically opening a workbook in "print preview", but PHPExcel certainly can't do this

Sep 6, 2011 at 9:28 PM

to push this issue a little... is there any solution for this problem? Excel supports definitly opening a workbook in "print preview" (showing headers/footers).