bulk_aggregate_workbooks
Combine and summarize matching worksheet or table data from multiple Excel files into a single aggregated result. Apply filters, group by fields, and compute metrics for cross-workbook analysis.
Instructions
Aggregate comparable worksheet or table data across multiple workbooks.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| filters | No | ||
| metrics | No | ||
| sort_by | No | ||
| group_by | No | ||
| row_mode | No | arrays | |
| filepaths | Yes | ||
| sort_desc | No | ||
| header_row | No | ||
| sheet_name | No | ||
| table_name | No | ||
| schema_mode | No | strict | |
| infer_schema | No | ||
| source_sample_limit | No |