废话不多说，直接上代码

public function export1()
  {
       //数据
       $data = [
           [
               'id' => 1,
               'username' => 1,
               'thumb' => 'F:\phpstudy\phpstudy_pro\WWW\education\public\uploads\image\1.jpg',//本地图片路径，如果你的图片不是本地，你还要先想办法把图片保存在本地
               'content' => 1,
               'create_time' => 1,
           ],
           [
               'id' => 2,
               'username' => 1,
               'thumb' => 'F:\phpstudy\phpstudy_pro\WWW\education\public\uploads\image\1.jpg',//本地图片路径
               'content' => 1,
               'create_time' => 1,
           ],
       ];

       //创建一个新的excel文档
       $newExcel = new \PhpOffice\PhpSpreadsheet\Spreadsheet();
       //获取当前操作sheet的对象
       $objSheet = $newExcel->getActiveSheet();
       //设置当前sheet的标题
       $objSheet->setTitle('意见反馈');
       //设置宽度为true,不然太窄了
       $newExcel->getActiveSheet()->getColumnDimension('A')->setWidth(10);
       $newExcel->getActiveSheet()->getColumnDimension('B')->setWidth(20);
       $newExcel->getActiveSheet()->getColumnDimension('C')->setWidth(20);
       $newExcel->getActiveSheet()->getColumnDimension('D')->setWidth(40);
       $newExcel->getActiveSheet()->getColumnDimension('E')->setWidth(30);
       //设置第一栏的标题
       $objSheet->setCellValue('A1', 'ID')
                ->setCellValue('B1', '用户')
                ->setCellValue('C1', '图片')
                ->setCellValue('D1', '内容')
                ->setCellValue('E1', '时间');

       if (!empty($data)) {
           foreach ($data as $key => $val) {
               $key = $key + 2;
               //设置第行高度
               $newExcel->getActiveSheet()->getRowDimension($key)->setRowHeight(65);
               //设置行值
               $objSheet->setCellValue('A' . $key, $val['id'])
                     ->setCellValue('B' . $key, $val['username'])
                     //->setCellValue('C' . $key, $val['thumb'][0])
                     ->setCellValue('D' . $key, $val['content'])
                     ->setCellValue('E' . $key, $val['create_time']);
               //处理图片
               if (!empty($val['thumb'])) {
                   $thumb = str_replace(request()->domain(), '.', $val['thumb']);
                   // halt($thumb);
                   $drawing[$key] = new \PhpOffice\PhpSpreadsheet\Worksheet\Drawing();
                   $drawing[$key]->setName('图片');
                   $drawing[$key]->setDescription('图片');
                   $drawing[$key]->setPath($thumb);
                   $drawing[$key]->setWidth(80);
                   $drawing[$key]->setHeight(80);
                   $drawing[$key]->setCoordinates('C'.$key);
                   $drawing[$key]->setOffsetX(0);
                   $drawing[$key]->setOffsetY(0);
                   $drawing[$key]->setWorksheet($newExcel->getActiveSheet());
               } else {
                   $objSheet->setCellValue('C' . $key, '');
               }
           }
       } else {
           $this->error('暂无数据');
       }
       //导出
       $filename = '意见反馈';
       $format = 'Xlsx';
       header('Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet');
       header("Content-Disposition: attachment;filename=" . $filename . date('Y-m-d') . '.' . strtolower($format));
       header('Cache-Control: max-age=0');
       $objWriter = \PhpOffice\PhpSpreadsheet\IOFactory::createWriter($newExcel, $format);
       return $objWriter->save('php://output');
       exit;
   }