PHP Excel image change size

php phpexcel xls
user198003 picture user198003 · Jul 10, 2012 · Viewed 20.1k times · Source

Developing PHP code that will create Excel file using PHP Excel.

I need to place an image into XLS file. Problem I have is that dimension of the image are not the one I defined in my code:

$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName('Water_Level');
$objDrawing->setDescription('Water_Level');
$objDrawing->setPath('img/logo-rab.jpg');
$objDrawing->setHeight(74);
$objDrawing->setCoordinates('A1');
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

This image is much higher than 74 pixels. Tried to add height and width also, but always the same.

Can you help me how to add image in my XLS, with dimensions I defined in PHP code?

Thank you in advance!

Answer

Fedy Venom picture Fedy Venom · Oct 1, 2014

Have you tried using setWidthAndHeight and set ResizeProportional true?

$objDrawing->setWidthAndHeight(148,74);
$objDrawing->setResizeProportional(true);

Related questions

PHP create xls from array

I try to create xls file from array and download it with the browser with this code: $sheet = array( array( 'a1 data', 'b1 data', 'c1 data', 'd1 data', ) ); $doc = new PHPExcel(); $doc->getActiveSheet()->fromArray($sheet, null, 'A1…

Read More
Read only specific sheet

I am trying to read just one sheet from an xls document and I have this: $objPHPExcel = $objReader->load('daily/' . $fisierInbound); $objWorksheet = $objPHPExcel->setActiveSheetIndex(0); foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) { $worksheetTitle = $worksheet->getTitle(); $highestRow = $worksheet->…

Read More
PHP - Codeigniter : Uncaught exception 'PHPExcel_Reader_Exception' with message 'Could not open for reading, File does not exist

My current CI project is now handling with files. i want to upload a xls| xlsx files to the server and then import excel file data into the Database table. as the first part , the file uploaded was successful, and …

Read More