phpxecel导出包含图片

$objDrawing = new \PHPExcel_Worksheet_Drawing(); //必须每次重新实例化

$objDrawing->setPath($_SERVER['DOCUMENT_ROOT']."/".ltrim(parse_url(图片路径l,PHP_URL_PATH),'/'));//这里是磁盘绝对路径

$objDrawing->setHeight(100);//照片高度

$objDrawing->setWidth(100);

$objDrawing->setCoordinates(表格的位置);

// 图片偏移距离

$objDrawing->setOffsetX(20);

$objDrawing->setOffsetY(25);

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

$objDrawing->setPath 这里是绝对路径，不然会提示找不到图片

到处多张图片

foreach (图片集合 as $kv => $vs) {

                                $objDrawing[$k] = new \PHPExcel_Worksheet_Drawing();

                                //图片路径,项目目录下就行

                                $objDrawing[$k]->setPath($_SERVER['DOCUMENT_ROOT']."/".ltrim(parse_url($vs,PHP_URL_PATH),'/'));

                                $objDrawing[$k]->setCoordinates(表格的位置);

                                $objDrawing[$k]->setWidth(100);

                                $objDrawing[$k]->setHeight(100);

                                //图片偏移距离

                                $objDrawing[$k]->setOffsetX(20);

                                $objDrawing[$k]->setOffsetY(25+$kv*101);//图片竖着排版

                                $objDrawing[$k]->setWorksheet($PHPExcel->getActiveSheet);

 }

文章来源: markwcm.blog.csdn.net，作者：黄啊码，版权归原作者所有，如需转载，请联系作者。

原文链接：markwcm.blog.csdn.net/article/details/105387354