本例是在Laravel里面使用了use Excel;
1、此方法適用于項(xiàng)目文件夾下的圖片
$img = "213123.png";
$objDrawing = new \PHPExcel_Worksheet_Drawing();
$objDrawing->setName('ZealImg');
$objDrawing->setDescription('Image inserted by Zeal');
$objDrawing->setPath($img);
$objDrawing->setHeight(250);
$objDrawing->setWidth(250);
$objDrawing->setCoordinates('A2');//單元格
$objDrawing->setOffsetX(20);//偏移量
$objDrawing->setOffsetY(20);
$objDrawing->setRotation(15);
$objDrawing->getShadow()->setVisible(true);
$objDrawing->getShadow()->setDirection(36);
$objDrawing->setWorksheet($sheet);//$sheet為當(dāng)前工作表
2夯膀、此方法適用網(wǎng)絡(luò)圖片苍蔬，通過GD創(chuàng)建畫布的方式實(shí)現(xiàn)
$img = 'http://www.xxx.com/image/1.png';
$img = $this->imagecreatefrompng($img);
$width = imagesx($img);
$height = imagesy($img);
$sheet->setSize($cell,$width/5,$height);//設(shè)置單元格 寬高
$objDrawing = new \PHPExcel_Worksheet_MemoryDrawing();
$objDrawing->setName('Sample image');
$objDrawing->setDescription('Sample image');
$objDrawing->setCoordinates($cell);
$objDrawing->setImageResource($img);
$objDrawing->setOffsetX(10);
$objDrawing->setOffsetY(10);
$objDrawing->setRenderingFunction(\PHPExcel_Worksheet_MemoryDrawing::RENDERING_DEFAULT);//渲染方法
$objDrawing->setMimeType(\PHPExcel_Worksheet_MemoryDrawing::MIMETYPE_DEFAULT);
$objDrawing->setHeight($height);
$objDrawing->setWorksheet($sheet);//同上
