# validate_range_name

> **Function** in `langchain_google_community`

📖 [View in docs](https://reference.langchain.com/python/langchain-google-community/sheets/utils/validate_range_name)

Validate and normalize a range name.

Permissive A1 validator. Supports:
- Single cells: `'A1'`, `'Z99'`
- Areas: `'A1:B2'`
- Whole columns: `'A:A'`, `'B:D'`
- Whole rows: `'1:1'`, `'5:10'`
- Sheet-qualified: `'Sheet1!A1'`, `"'My Sheet'!A1:B2"`
- Named ranges: `'MyData'`, `'Sales_2024'`

## Signature

```python
validate_range_name(
    range_name: str,
) -> str
```

## Parameters

| Name | Type | Required | Description |
|------|------|----------|-------------|
| `range_name` | `str` | Yes | The range name to validate (e.g., `'A1:Z100'`, `'Sheet1!A1:B2'`). |

## Returns

`str`

The validated range name.

---

[View source on GitHub](https://github.com/langchain-ai/langchain-google/blob/6b6f1e8aa4053d9914ab0b58ee16c21364897842/libs/community/langchain_google_community/sheets/utils.py#L202)