| 197 | } |
| 198 | |
| 199 | private function validateRanges(string $rangeList): ?string { |
| 200 | $ranges = str_getcsv($rangeList); |
| 201 | $totalCells = 0; |
| 202 | foreach ($ranges as $range) { |
| 203 | $range = strtoupper(trim($range)); |
| 204 | if ($range === '') { |
| 205 | return $this->l10n->t('Invalid spreadsheet range'); |
| 206 | } |
| 207 | |
| 208 | if (preg_match('/^(?<startColumn>[A-Z]{1,3})(?<startRow>[1-9][0-9]*)(?::(?<endColumn>[A-Z]{1,3})(?<endRow>[1-9][0-9]*))?$/', $range, $matches) !== 1) { |
| 209 | return $this->l10n->t('Invalid spreadsheet range'); |
| 210 | } |
| 211 | |
| 212 | $endColumn = ($matches['endColumn'] ?? '') !== '' ? $matches['endColumn'] : $matches['startColumn']; |
| 213 | $endRow = ($matches['endRow'] ?? '') !== '' ? $matches['endRow'] : $matches['startRow']; |
| 214 | $rows = abs((int)$endRow - (int)$matches['startRow']) + 1; |
| 215 | if ($rows > self::MAX_RANGE_ROWS) { |
| 216 | return $this->l10n->t('Spreadsheet range is too large'); |
| 217 | } |
| 218 | |
| 219 | try { |
| 220 | [$startColumn] = Coordinate::coordinateFromString($matches['startColumn'] . $matches['startRow']); |
| 221 | [$validatedEndColumn] = Coordinate::coordinateFromString($endColumn . $endRow); |
| 222 | $columns = abs(Coordinate::columnIndexFromString($validatedEndColumn) - Coordinate::columnIndexFromString($startColumn)) + 1; |
| 223 | } catch (\PhpOffice\PhpSpreadsheet\Exception $e) { |
| 224 | return $this->l10n->t('Invalid spreadsheet range'); |
| 225 | } |
| 226 | $totalCells += $columns * $rows; |
| 227 | |
| 228 | if ($totalCells > self::MAX_RANGE_CELLS) { |
| 229 | return $this->l10n->t('Spreadsheet range is too large'); |
| 230 | } |
| 231 | } |
| 232 | |
| 233 | return null; |
| 234 | } |
| 235 | |
| 236 | private function removeNullColumns(array $data): array { |
| 237 | // Transpose the data to work with columns as rows |