Add Number Validation
add_number_validationRestrict an Excel range to numbers that meet a specified condition, such as greater than or between values. Set decimal allowance and apply validation to a target range.
Instructions
Restrict a range to numbers matching a comparison.
Args: workbook: Workbook name or path (None = active workbook). sheet: Worksheet name (None = active sheet). range_address: A1-style address, e.g. "B2:B20". condition: One of "greater_than", "less_than", "greater_equal", "less_equal", "equal_to", "not_equal", "between", "not_between". value1: Comparison value (required). value2: Second comparison value, required only for "between"/ "not_between". decimal: Allow decimals (False = whole numbers only).
Returns: JSON confirmation.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet | No | ||
| value1 | No | ||
| value2 | No | ||
| decimal | No | ||
| workbook | No | ||
| condition | No | greater_than | |
| range_address | No | A1 |