PhpSpreadsheet can't retrieve images placed inside cell

[AntonioA-D-C]

  
    $spreadsheet=  IOFactory::load($this->file);
    $i= 0;
    dd($spreadsheet->getActiveSheet($row)->getDrawingCollection());
    foreach ($spreadsheet->getActiveSheet()->getDrawingCollection() as $drawing) {
      if ($drawing instanceof MemoryDrawing) {
          ob_start();
          call_user_func(
              $drawing->getRenderingFunction(),
              $drawing->getImageResource()
          );
          $imageContents = ob_get_contents();
          ob_end_clean();
          switch ($drawing->getMimeType()) {
              case MemoryDrawing::MIMETYPE_PNG :
                  $extension = 'png';
                  break;
              case MemoryDrawing::MIMETYPE_GIF:
                  $extension = 'gif';
                  break;
              case MemoryDrawing::MIMETYPE_JPEG :
                  $extension = 'jpg';
                  break;
          }
      } else {
          $zipReader = fopen($drawing->getPath(), 'r');
          $imageContents = '';
          while (!feof($zipReader)) {
              $imageContents .= fread($zipReader, 1024);
          }
          fclose($zipReader);
          $extension = $drawing->getExtension();
      }
    
      $myFileName = time() .++$i. '.' . $extension;
      dd($myFileName);
    }

Here my script won't trigger when I have images that are inside cells, it ignores images inside the cells for images outside the cells, how to fix this or how to retrieve images contained within cells

[oleibman]

Confirming what you've already surmised. PhpSpreadsheet has no way to set a cell value to an image. As for retrieving such an image, I've looked at a spreadsheet which does this, and I really don't see how this is handled in the xml. Even if I do figure it out, it would probably be a pretty major change to extend the set of datatypes to which a cell value can be set.

[oleibman]

Closing as duplicate of #4034.