PHPOffice /
PhpSpreadsheet
| @@ 126-144 (lines=19) @@ | ||
| 123 | ||
| 124 | return (int) Cell::columnIndexFromString($columnKey); |
|
| 125 | } |
|
| 126 | } else { |
|
| 127 | if (strpos($cellAddress, '!') !== false) { |
|
| 128 | list($sheet, $cellAddress) = explode('!', $cellAddress); |
|
| 129 | } |
|
| 130 | if (strpos($cellAddress, ':') !== false) { |
|
| 131 | list($startAddress, $endAddress) = explode(':', $cellAddress); |
|
| 132 | $startAddress = preg_replace('/[^a-z]/i', '', $startAddress); |
|
| 133 | $endAddress = preg_replace('/[^a-z]/i', '', $endAddress); |
|
| 134 | $returnValue = []; |
|
| 135 | do { |
|
| 136 | $returnValue[] = (int) Cell::columnIndexFromString($startAddress); |
|
| 137 | } while ($startAddress++ != $endAddress); |
|
| 138 | ||
| 139 | return $returnValue; |
|
| 140 | } |
|
| 141 | $cellAddress = preg_replace('/[^a-z]/i', '', $cellAddress); |
|
| 142 | ||
| 143 | return (int) Cell::columnIndexFromString($cellAddress); |
|
| 144 | } |
|
| 145 | } |
|
| 146 | ||
| 147 | /** |
|
| @@ 207-225 (lines=19) @@ | ||
| 204 | return (int) preg_replace('/[^0-9]/', '', $rowKey); |
|
| 205 | } |
|
| 206 | } |
|
| 207 | } else { |
|
| 208 | if (strpos($cellAddress, '!') !== false) { |
|
| 209 | list($sheet, $cellAddress) = explode('!', $cellAddress); |
|
| 210 | } |
|
| 211 | if (strpos($cellAddress, ':') !== false) { |
|
| 212 | list($startAddress, $endAddress) = explode(':', $cellAddress); |
|
| 213 | $startAddress = preg_replace('/[^0-9]/', '', $startAddress); |
|
| 214 | $endAddress = preg_replace('/[^0-9]/', '', $endAddress); |
|
| 215 | $returnValue = []; |
|
| 216 | do { |
|
| 217 | $returnValue[][] = (int) $startAddress; |
|
| 218 | } while ($startAddress++ != $endAddress); |
|
| 219 | ||
| 220 | return $returnValue; |
|
| 221 | } |
|
| 222 | list($cellAddress) = explode(':', $cellAddress); |
|
| 223 | ||
| 224 | return (int) preg_replace('/[^0-9]/', '', $cellAddress); |
|
| 225 | } |
|
| 226 | } |
|
| 227 | ||
| 228 | /** |
|
