Is it possible to put the text under the image in the header or footer in phpExcel?

Based on phpexcel_library / 1.7.4 / manual.html I can insert text under the image, but is there a way to put text under the image?

This is my code for the footer:

$workbook = new PHPExcel(); $objDrawing = new PHPExcel_Worksheet_HeaderFooterDrawing(); $objDrawing->setName('Footer Logo'); $objDrawing->setPath("footer_logo.png"); $objDrawing->setHeight(100); $workbook->getActiveSheet() ->getHeaderFooter() ->addImage($objDrawing, PHPExcel_Worksheet_HeaderFooter::IMAGE_FOOTER_CENTER); $workbook->getActiveSheet() ->getHeaderFooter() ->setOddFooter('&G&CVisible text behind the transparent image.'); $workbook->getActiveSheet() ->getHeaderFooter() ->setEvenFooter('&G&CVisible text behind the transparent image.'); 
+7
php phpexcel
source share
1 answer

Try this, I'm sure it will give you an idea of ​​what you can do.

http://doclecture.net/1-57789.html

using setOddFooter ($ objDrawing ..... will give you access to it.

+1
source share

All Articles