Method validateRanges

lib/Datasource/LocalSpreadsheet.php:182–217

(string $rangeList)

	}

	private function validateRanges(string $rangeList): ?string {
		$ranges = str_getcsv($rangeList);
		$totalCells = 0;
		foreach ($ranges as $range) {
			$range = strtoupper(trim($range));
			if ($range === '') {
				return $this->l10n->t('Invalid spreadsheet range');
			}

			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) {
				return $this->l10n->t('Invalid spreadsheet range');
			}

			$endColumn = ($matches['endColumn'] ?? '') !== '' ? $matches['endColumn'] : $matches['startColumn'];
			$endRow = ($matches['endRow'] ?? '') !== '' ? $matches['endRow'] : $matches['startRow'];
			$rows = abs((int)$endRow - (int)$matches['startRow']) + 1;
			if ($rows > self::MAX_RANGE_ROWS) {
				return $this->l10n->t('Spreadsheet range is too large');
			}

			try {
				[$startColumn] = Coordinate::coordinateFromString($matches['startColumn'] . $matches['startRow']);
				[$validatedEndColumn] = Coordinate::coordinateFromString($endColumn . $endRow);
				$columns = abs(Coordinate::columnIndexFromString($validatedEndColumn) - Coordinate::columnIndexFromString($startColumn)) + 1;
			} catch (\PhpOffice\PhpSpreadsheet\Exception $e) {
				return $this->l10n->t('Invalid spreadsheet range');
			}
			$totalCells += $columns * $rows;

			if ($totalCells > self::MAX_RANGE_CELLS) {
				return $this->l10n->t('Spreadsheet range is too large');
			}
		}

		return null;
	}

	private function removeNullColumns(array $data): array {
		// Transpose the data to work with columns as rows