multi_file
Aggregate, filter, validate schema consistency, or compare multiple Excel workbooks. Specify action, file paths, and parameters to get results or write output files.
Instructions
Perform cross-workbook operations: aggregate, filter, validate schema consistency, compare two workbooks.
Args:
action: "aggregate", "filter", "validate", or "compare".
- "aggregate": requires file_paths and column; returns aggregated metric.
- "filter": requires file_paths, column, operator, value; returns filtered rows or writes to output_file.
- "validate": requires file_paths and key_column; checks schema/consistency across files.
- "compare": requires file_a and file_b; returns diff summary and optionally writes a report.
file_paths, file_a, file_b: File list / pair for relevant actions.
column, operation, operator, value: Parameters for aggregation/filtering.
output_file: Optional path to write the result.
Returns: dict: Operation-specific result (e.g. aggregation numbers, diffs, validation errors).
Notes:
- When output_file is provided operations may write new files — document overwrite policy.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| value | No | ||
| action | Yes | ||
| column | No | ||
| file_a | No | ||
| file_b | No | ||
| operator | No | ||
| operation | No | sum | |
| file_paths | No | ||
| header_row | No | ||
| key_column | No | ||
| sheet_name | No | Sheet1 | |
| output_file | No | ||
| sheet_name_b | No | ||
| check_columns | No | ||
| compare_values | No | ||
| compare_formulas | No |