Data validation
xlide_manage_validationDestructiveIdempotent
List, add, or clear data validation rules in Excel to control cell input and create dropdowns.
Instructions
Lists, adds or clears data validation: what a cell will accept, and the dropdown it shows. kind='list' with formula1 as a comma-separated set of values gives a dropdown; kind='list' with a range reference gives one driven by cells. The other kinds take an operator and one or two formulas, which may be literals or references. Validation stops typing in Excel, not writing through this server, and Excel does not re-check cells that already held a value.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| kind | No | whole, decimal, list, date, time, textLength or custom. | list |
| sheet | Yes | Worksheet name, matched without case. | |
| action | No | list, add or clear. | list |
| formula1 | No | The allowed values. For kind='list', either 'Red,Green,Blue' or a range like $H$1:$H$9. For the others, the bound, such as 0. | |
| formula2 | No | The second bound, for between and notBetween. | |
| operator | No | between, greaterThan, lessThan and so on. | between |
| file_path | Yes | Absolute path to the Excel file. | |
| cell_range | No | For add and clear: the range. Empty clears the whole sheet. | |
| allow_blank | No | Let the cell be left empty. | |
| error_message | No | What Excel says when the entry is refused. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||