I am using PHP Excel library and have a problem.
I need to insert into a cell image as hyperlink. Is it possible, any suggesions?
Tryed to dran an image
$image = imagecreatefromjpeg($imagePath);
$objDrawing = new PHPExcel_Worksheet_MemoryDrawing();
$objDrawing->setImageResource($image);
$columnLetter = PHPExcel_Cell::stringFromColumnIndex($columnIndex - 1);
$this->imageColumns[$columnLetter] = 1;
$coordinate = $columnLetter . $rowIndex;
$objDrawing->setCoordinates($coordinate);
$objDrawing->setResizeProportional(false);
$objDrawing->setRenderingFunction(PHPExcel_Worksheet_MemoryDrawing::RENDERING_JPEG);
$objDrawing->setMimeType(PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT);
$objDrawing->setWorksheet($this->objPHPExcel->getActiveSheet());
->getCell()->getHyperlink()->setUrl('url');
– user1362776 Apr 19 at 7:06