@@ 6941-6959 (lines=19) @@ | ||
6938 | * @param string $subData |
|
6939 | * @return array |
|
6940 | */ |
|
6941 | private function readBIFF8CellRangeAddressList($subData) |
|
6942 | { |
|
6943 | $cellRangeAddresses = []; |
|
6944 | ||
6945 | // offset: 0; size: 2; number of the following cell range addresses |
|
6946 | $nm = self::getInt2d($subData, 0); |
|
6947 | ||
6948 | $offset = 2; |
|
6949 | // offset: 2; size: 8 * $nm; list of $nm (fixed) cell range addresses |
|
6950 | for ($i = 0; $i < $nm; ++$i) { |
|
6951 | $cellRangeAddresses[] = $this->readBIFF8CellRangeAddressFixed(substr($subData, $offset, 8)); |
|
6952 | $offset += 8; |
|
6953 | } |
|
6954 | ||
6955 | return [ |
|
6956 | 'size' => 2 + 8 * $nm, |
|
6957 | 'cellRangeAddresses' => $cellRangeAddresses, |
|
6958 | ]; |
|
6959 | } |
|
6960 | ||
6961 | /** |
|
6962 | * Read BIFF5 cell range address list |
|
@@ 6968-6986 (lines=19) @@ | ||
6965 | * @param string $subData |
|
6966 | * @return array |
|
6967 | */ |
|
6968 | private function readBIFF5CellRangeAddressList($subData) |
|
6969 | { |
|
6970 | $cellRangeAddresses = []; |
|
6971 | ||
6972 | // offset: 0; size: 2; number of the following cell range addresses |
|
6973 | $nm = self::getInt2d($subData, 0); |
|
6974 | ||
6975 | $offset = 2; |
|
6976 | // offset: 2; size: 6 * $nm; list of $nm (fixed) cell range addresses |
|
6977 | for ($i = 0; $i < $nm; ++$i) { |
|
6978 | $cellRangeAddresses[] = $this->readBIFF5CellRangeAddressFixed(substr($subData, $offset, 6)); |
|
6979 | $offset += 6; |
|
6980 | } |
|
6981 | ||
6982 | return [ |
|
6983 | 'size' => 2 + 6 * $nm, |
|
6984 | 'cellRangeAddresses' => $cellRangeAddresses, |
|
6985 | ]; |
|
6986 | } |
|
6987 | ||
6988 | /** |
|
6989 | * Get a sheet range like Sheet1:Sheet3 from REF index |