Как получить картинки из .xlsx?

Question

[Drammm]

Есть экселевский прайс с картинками.
Пробую его читать библиотекой PHPSPREADSHEET - тестовые поля достаются, а картинки нет.
Нигде не могу нагуглить примеры чтения картинок - не поможете?

Comments

[sweet_maks]

Из документации:

A commonly asked question is how to retrieve the images from a workbook that has been loaded, and save them as individual image files to disk.
The following code extracts images from the current active worksheet, and writes each as a separate file.

$i = 0;
foreach ($spreadsheet->getActiveSheet()->getDrawingCollection() as $drawing) {
    if ($drawing instanceof \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing) {
        ob_start();
        call_user_func(
            $drawing->getRenderingFunction(),
            $drawing->getImageResource()
        );
        $imageContents = ob_get_contents();
        ob_end_clean();
        switch ($drawing->getMimeType()) {
            case \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::MIMETYPE_PNG :
                $extension = 'png';
                break;
            case \PhpOffice\PhpSpreadsheet\Worksheet\MemoryDrawing::MIMETYPE_GIF:
                $extension = 'gif';
                break;
            case \PhpOffice\PhpSpreadsheet\Worksheet\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 = '00_Image_'.++$i.'.'.$extension;
    file_put_contents($myFileName,$imageContents);
}

Answer 1

[Вадим]

Эта либа умеет такое: https://github.com/aVadim483/fast-excel-reader