ccc

PHPExcel: Añadir imágenes al Excel

$objDrawing = new PHPExcel_Worksheet_Drawing();    //create object for Worksheet drawing
$objDrawing->setName('Customer Signature');        //set name to image
$objDrawing->setDescription('Customer Signature'); //set description to image
$signature = '../../imagenes/proyectos-grandes/'.$db2->Record['img1'];    //Path to signature .jpg file
$objDrawing->setPath($signature);
$objDrawing->setOffsetX(25);                       //setOffsetX works properly
$objDrawing->setOffsetY(10);                       //setOffsetY works properly
$objDrawing->setCoordinates('B'.$i);        //set image to cell
$objDrawing->setWidth(32);                 //set width, height
$objDrawing->setHeight(32);

$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());

No hay comentarios:

Publicar un comentario