How to put Picture in a footer in PHPecxel report

Topics: Developer Forum, Project Management Forum, User Forum
Mar 17, 2014 at 3:40 AM
Hello everyone when i tried this for a header it works but when i tried it for a footer it wont work can anyone help me how to make this work? I want the picture to be my footer can anyone help me with this please.
$objPHPExcel->getActiveSheet()->getHeaderFooter()->setOddFooter('&C&G');
$objDrawing = new PHPExcel_Worksheet_HeaderFooterDrawing();
        $objDrawing->setName('PHPExcel logo');
        $objDrawing->setPath('images/footerpicture.png');
        $objDrawing->setHeight(36);
        $objPHPExcel->getActiveSheet()->getHeaderFooter()->addImage($objDrawing, PHPExcel_Worksheet_HeaderFooter::IMAGE_FOOTER_CENTER);