PHPOffice / PhpSpreadsheet

     *

     * @return array

     */

    private function readBIFF8CellRangeAddressList($subData)

    {

        $cellRangeAddresses = [];

        // offset: 0; size: 2; number of the following cell range addresses

        $nm = self::getUInt2d($subData, 0);

        $offset = 2;

        // offset: 2; size: 8 * $nm; list of $nm (fixed) cell range addresses

        for ($i = 0; $i < $nm; ++$i) {

            $cellRangeAddresses[] = $this->readBIFF8CellRangeAddressFixed(substr($subData, $offset, 8));

            $offset += 8;

        }

        return [

            'size' => 2 + 8 * $nm,

            'cellRangeAddresses' => $cellRangeAddresses,

        ];

    }

    /**

     * Read BIFF5 cell range address list

     *

     * @return array

     */

    private function readBIFF5CellRangeAddressList($subData)

    {

        $cellRangeAddresses = [];

        // offset: 0; size: 2; number of the following cell range addresses

        $nm = self::getUInt2d($subData, 0);

        $offset = 2;

        // offset: 2; size: 6 * $nm; list of $nm (fixed) cell range addresses

        for ($i = 0; $i < $nm; ++$i) {

            $cellRangeAddresses[] = $this->readBIFF5CellRangeAddressFixed(substr($subData, $offset, 6));

            $offset += 6;

        }

        return [

            'size' => 2 + 6 * $nm,

            'cellRangeAddresses' => $cellRangeAddresses,

        ];

    }

    /**

     * Get a sheet range like Sheet1:Sheet3 from REF index