Add an image into a PHPExcel cell
Add an image into a PHPExcel cell
The following assumes a dataobject ($obj) with a has_one Image (called image) and adds that to a cell in phpexcell worksheet
$oCell->setValue('');
if ($obj->ImageID && file_exists($obj->Image()->getFullPath())) {
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName('PHPExcel image');
$objDrawing->setDescription('PHPExcel image');
$objDrawing->setPath($obj->Image()->getFullPath());
$objDrawing->setHeight(100);
$objDrawing->setCoordinates($oCell->getCoordinate());
$objDrawing->setOffsetX(100);
$objDrawing->setWorksheet($oSheet);
}