equire_once './Classes/PHPExcel.php';
$objPHPExcel = new PHPExcel();
$objReader = PHPExcel_IOFactory::createReader('Excel5'); //加载2003的
$objPHPExcel = $objReader->load("goods_list.xls"); //载入文件
foreach ($objPHPExcel->getSheet(0)->getDrawingCollection() as $k => $drawing) {
$codata = $drawing->getCoordinates(); //得到单元数据 比如G2单元
$filename = $drawing->getIndexedFilename(); //文件名
ob_start();
call_user_func(
$drawing->getRenderingFunction(),
$drawing->getImageResource()
);
$p_w_picpathContents = ob_get_contents();
file_put_contents('pic/'.$codata.'_'.$filename.'.jpg',$p_w_picpathContents); //把文件保存到本地
ob_end_clean();
}
转载于:https://blog.51cto.com/09261125/1688165