筛选区域
filter_rangeFilter rows in an Excel range based on multiple conditions (AND logic) and return matching results without modifying the original file.
Instructions
按条件筛选区域中的行并返回结果,不修改文件。多个条件为'并且'关系。
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| range | Yes | 矩形区域,如 `A1:D20` | |
| filePath | Yes | Excel 文件的绝对路径,例如 `C:\Users\xx\报表.xlsx` 或 `/Users/xx/报表.xlsx`。支持 .xlsx / .xls / .csv | |
| hasHeader | No | ||
| sheetName | Yes | ||
| conditions | Yes |