PHPOffice / PhpSpreadsheet

    /**

     * Read BlipJPEG record. Holds raw JPEG image data

     */

    private function readBlipJPEG()

    {

        // offset: 0; size: 2; recVer and recInstance

        // bit: 4-15; mask: 0xFFF0; recInstance

        $recInstance = (0xFFF0 & \PhpOffice\PhpSpreadsheet\Reader\Xls::getInt2d($this->data, $this->pos)) >> 4;

        $length = \PhpOffice\PhpSpreadsheet\Reader\Xls::getInt4d($this->data, $this->pos + 4);

        $recordData = substr($this->data, $this->pos + 8, $length);

        // move stream pointer to next record

        $this->pos += 8 + $length;

        $pos = 0;

        // offset: 0; size: 16; rgbUid1 (MD4 digest of)

        $rgbUid1 = substr($recordData, 0, 16);

        $pos += 16;

        // offset: 16; size: 16; rgbUid2 (MD4 digest), only if $recInstance = 0x46B or 0x6E3

        if (in_array($recInstance, [0x046B, 0x06E3])) {

            $rgbUid2 = substr($recordData, 16, 16);

            $pos += 16;

        }

        // offset: var; size: 1; tag

        $tag = ord($recordData{$pos});

        $pos += 1;

        // offset: var; size: var; the raw image data

        $data = substr($recordData, $pos);

        $blip = new \PhpOffice\PhpSpreadsheet\Shared\Escher\DggContainer\BstoreContainer\BSE\Blip();

        $blip->setData($data);

        $this->object->setBlip($blip);

    }

    /**

     * Read BlipPNG record. Holds raw PNG image data

    /**

     * Read BlipPNG record. Holds raw PNG image data

     */

    private function readBlipPNG()

    {

        // offset: 0; size: 2; recVer and recInstance

        // bit: 4-15; mask: 0xFFF0; recInstance

        $recInstance = (0xFFF0 & \PhpOffice\PhpSpreadsheet\Reader\Xls::getInt2d($this->data, $this->pos)) >> 4;

        $length = \PhpOffice\PhpSpreadsheet\Reader\Xls::getInt4d($this->data, $this->pos + 4);

        $recordData = substr($this->data, $this->pos + 8, $length);

        // move stream pointer to next record

        $this->pos += 8 + $length;

        $pos = 0;

        // offset: 0; size: 16; rgbUid1 (MD4 digest of)

        $rgbUid1 = substr($recordData, 0, 16);

        $pos += 16;

        // offset: 16; size: 16; rgbUid2 (MD4 digest), only if $recInstance = 0x46B or 0x6E3

        if ($recInstance == 0x06E1) {

            $rgbUid2 = substr($recordData, 16, 16);

            $pos += 16;

        }

        // offset: var; size: 1; tag

        $tag = ord($recordData{$pos});

        $pos += 1;

        // offset: var; size: var; the raw image data

        $data = substr($recordData, $pos);

        $blip = new \PhpOffice\PhpSpreadsheet\Shared\Escher\DggContainer\BstoreContainer\BSE\Blip();

        $blip->setData($data);

        $this->object->setBlip($blip);

    }

    /**

     * Read OPT record. This record may occur within DggContainer record or SpContainer