php导出图片到excel,phpexcel导出图片

phpexcel导出图片

foreach($list as $l){

/*实例化插入图片类*/

$objDrawing = new PHPExcel_Worksheet_Drawing();

/*设置图片路径 切记：只能是本地图片*/

if(!is_file(ROOT_PATH .$l[‘goods_thumb’])){

$l[‘goods_thumb’] = “images/no_picture.gif”;

}

$objDrawing->setPath(ROOT_PATH . $l[‘goods_thumb’]);

/*设置图片高度*/

$objDrawing->setResizeProportional(false);

$objDrawing->setWidth(100);

$objDrawing->setHeight(100);

/*设置图片要插入的单元格*/

$objDrawing->setCoordinates(‘D’ . $i);

/*设置图片所在单元格的格式*/

$objDrawing->setOffsetX(10);

$objDrawing->setOffsetY(10);

$objDrawing->setRotation(20);

$objDrawing->getShadow()->setVisible(true);

$objDrawing->getShadow()->setDirection(50);

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

$objPHPExcel->getActiveSheet()->getRowDimension($i)->setRowHeight(100);

$i++;

$j++;

}

标签：phpexcel