$drawing = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
$drawing->setName('Logo');//設置圖片名稱
$drawing->setDescription('Logo');//設備圖片描述
$drawing->setPath('./images/officelogo.jpg');//設置圖片地址
$drawing->setHeight(36);//設置圖片高度
$drawing->setCoordinates('A1');//設置圖片繪制到指定單元格
$drawing->setWorksheet($spreadsheet->getActiveSheet());//將圖片繪制到工作表

$spreadsheet = new Spreadsheet();//創(chuàng)建一個新的excel文檔
$sheet = $spreadsheet->getActiveSheet();//獲取當前操作sheet的對象
//將圖片繪制到excel中
$drawing = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
$drawing->setPath($img);
$drawing->setHeight(50);
$drawing->setCoordinates('A1');
$drawing->setWorksheet($sheet);
$writer = new Xlsx($spreadsheet);
$writer->save('xxx.xlsx');//生成excel文件
//將多個圖片繪制到excel中
$spreadsheet = new Spreadsheet();//創(chuàng)建一個新的excel文檔
$sheet = $spreadsheet->getActiveSheet();//獲取當前操作sheet的對象
//將圖片繪制到excel中
foreach ($imgs as $img) {
    $drawing = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
    $drawing->setPath($img);
    $drawing->setHeight(50);
    $drawing->setCoordinates('A1');
    $drawing->setWorksheet($sheet);
}
$writer = new Xlsx($spreadsheet);
$writer->save('xxx.xlsx');//生成excel文件