filter_data_advanced
Filter spreadsheet rows by multiple conditions combined with AND/OR logic. Define column, operator, and value for each filter, with optional output to a new sheet.
Instructions
Filter rows using multiple conditions combined with AND/OR logic.
Args: file_path: Workbook path. sheet_name: Worksheet name. conditions: List of filter conditions, each with 'column' (str), 'operator' (str), and 'value'. logic: "AND" or "OR" to combine conditions. output_sheet: Optional sheet to write filtered output. header_row: 1-based header row index.
Returns: dict: Filtered rows or summary.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| logic | No | AND | |
| file_path | Yes | ||
| conditions | Yes | ||
| header_row | No | ||
| sheet_name | Yes | ||
| output_sheet | No |