phpexcelで画像を含むExcelの幅設定に関連する問題

phpexcelは、写真でExcelの幅の設定の問題を注ぎます🎜> require_once ROOT_PATH.'includes/PHPExcel/PHPExcel/IOFactory.php';
// 新しい PHPExcel オブジェクトを作成します
$objPHPExcel = new PHPExcel();
// プロパティを設定します
$objPHPExcel- >getProperties()->setCreator("DizzyLion")
->setLastModifiedBy("DizzyLion")
->setSubject("注文出力ドキュメント") ;
$filepaths= ROOT_PATH。 data/".date("Y-m").'.xls';
$filename = date("Y-m").'.xls';
$rowix = 1;> 注文時刻')
->setCellValue('C'.$rowix, '注文金額')
-->setCellValue('D'.$rowix, '商品画像')
-> ;setCellValue('E' .$rowix , 'メンバー名');

$rowix ;
$i=0;
$list = array();
$order_sn_list =explode (',', $ _POST['order_id']);
foreach ($order_sn_list as $order_sn)
{
/* 注文情報を取得 */
$sql = "s select pay_name,shipping_name ,order_id,order_sn, consignee,address,add_time,tel,mobile,user_name," . ('order_info')." o left join ".$ecs->table('users')." u on o.user_id =
u. user_id where order_sn='$order_sn'";
$ row = $db->getRow($sql);
$goods = $db->getAll("select Goods_name,goods_id,cgbz,postmsg, Goods_number,goods_price,goods_price*goods_number as je,goods_sn from ".$ecs->table('order_goods')." where order_id = '".$row['order_id']."'");
if ($goods){
foreach($goods as $ k=>$v){
$temp = array();
$v['img'] = $db->getOne( "select Goods_thumb from ".$ecs->table(' Goods')." where Goods_id='".$v['goods_id']."'");
$temp['goods'] = $ v;
$temp['order_info'] = $ row;
$list[$row['order_id']][] = $temp;
}
}
}

foreach ($list as $key =>$t) {
foreach($t as $k1=>$value){

$objPHPExcel->setActiveSheetIndex(0)
—>setCellValue('A'.$rowix , $value['order_info']['order_sn'])
->setCellValue('B'.$rowix , local_date("Y-m-d",$ value ['order_info'] ['add_time']）
- 'user_name'];
$ objphpexcel-＆gt; getColumndimension（ 'd'。$ rowix） - ＆gt ;setAutoSize(true); )->getColumnDimension('D'.$rowix)->setWidth(150); //列 D を設定、画像列の幅は 150

$objPHPExcel- >getActiveSheet()-> getRowDimension($rowix)->setRowHeight(80);
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setName('Logo');
$objDrawing->setDescription(' ロゴ');
$objDrawing->setPath("../".$value['goods']['img']);
$objDrawing->setHeight(80);
$objDrawing->setCoowned( 'D'.$rowix);//図片名が存在する单元格
$objDrawing->getShadow()->setVisible(true);
$objDrawing->setWorksheet($objPHPExcel->gt; getActiveSheet());
$rowix ;
}
}
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('A')->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('B')->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('C')-> ;setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)->getColumnDimension('D')->setAutoSize(true);
$objPHPExcel->setActiveSheetIndex(0)-> getColumnDimension('E')->setAutoSize(true);;
$objPHPExcel->setActiveSheetIndex(0);
$objWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel5');
$objWriter->setTempDir(ROOT_PATH."data");

$objWriter->save($filepaths);

header("Location:../data/".$ filename);
exit;

}
?>

D 列是图片表示的内容列，但是我设置了 150，可是程序里面倒出来，还是很狭い，没效果
-----解决方案---------
怎么能删呢?
应写作
$objPHPExcel->getActiveSheet()->getColumnDimension('D')->setWidth(150);