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