Based on phpexcel_library/1.7.4/manual.html I can insert the text below the image, but is there a way to put text under the picture?
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.');
Go to Insert > Header or Footer > Blank. Double-click Type here in the header or footer area. Select Picture from File, choose your picture, and select Insert to add the picture.
Click in the header or footer section where the image is located. Click in the &[Picture] text of the image. On the Design tab under Header & Footer Tools, click Format Picture in the Header & Footer Elements group. On the Size tab, adjust the size of the image to fit inside the header or footer section.
To increase the width of multiple consecutive columns, select the columns you want to change. Click the header boundary of any selected column and drag to the right, like in the picture below. To decrease the width, drag to the left.
Try this , I am sure it will give you an idea about what you can do .
http://doclecture.net/1-57789.html
using setOddFooter($objDrawing ..... will give you the access to it.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With