Find Excel cell error indicators
xlide_check_cellsDetect Excel cells flagged with green error-checking triangles, such as text-formatted numbers or inconsistent formulas, and return each rule and cell for review.
Instructions
Lists cells Excel would mark with a green error-checking triangle, such as numbers stored as text, inconsistent formulas, or formulas with cached errors. Returns the rule and cell for each finding. Excel hides ignored findings unless include_ignored=true. Formula-dependent checks use the file's cached results, which may be stale until Excel recalculates and saves it. Works on .xlsx, .xlsm and .xlam; page through long lists with offset and next_offset.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| rules | No | Excel error-rule names; omit for its enabled rules. | |
| sheet | Yes | Worksheet name, matched without case. | |
| offset | No | Findings to skip. | |
| file_path | Yes | Absolute path to the Excel file. | |
| max_results | No | Most findings to return. | |
| include_ignored | No | Include findings Excel was told to ignore. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||