为什么无论PHPExcel和Spreadsheet插入图片,只要同一行其他列有自动换行。图片就会自动拉伸变形?并且设置了图片宽高,取消按比例都没用?
$drawingContent = new Drawing();
foreach ($listDatas as $item) {
// 插入图片
$drawingContent->setPath($item[3])
->setCoordinates('D' . $row)
->setResizeProportional(false)
->setWidthAndHeight(50, 50)
->setWorksheet($sheet);
$sheet->setCellValue('A' . $row, $item[0]);
$sheet->setCellValue('B' . $row, $item[1]);
$sheet->setCellValue('C' . $row, $item[2]);
$sheet->setCellValue('E' . $row, $item[4]);
$sheet->setCellValue('F' . $row, $item[5]);
$sheet->setCellValue('G' . $row, $item[6]);
$sheet->setCellValue('H' . $row, $item[7]);
$sheet->setCellValue('I' . $row, $item[8]);
$sheet->setCellValue('J' . $row, $item[9]);
$sheet->setCellValue('K' . $row, $item[10]);
$sheet->setCellValue('L' . $row, $item[11]);
$sheet->setCellValue('M' . $row, $item[12]);
$sheet->setCellValue('N' . $row, $item[13]);
$sheet->setCellValue('O' . $row, $item[14]);
$row++;
}
// 居中
$sheet->getStyle('A9:C'.$row)->applyFromArray($styleArray);
$sheet->getStyle('E9:O'.$row)->applyFromArray($styleArray);
希望图片能按宽高设置去实现