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??