compare_sheets
Compare two worksheets by key column to show rows only in each sheet and value changes. Returns summary stats and up to max_diff details for version comparison, change detection, reconciliation.
Instructions
按关键列比对两个工作表的差异 —— 只回传差异摘要,不回传整表。
用途:版本对比、变更检测、对账。
返回:仅在表1 / 仅在表2 / 值有差异 三类统计, 以及最多 max_diff 条差异明细(超出会明确说明截断数量,以统计值为准)。
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"file_path": "<file_path>",
"sheet1": "<sheet1>",
"sheet2": "<sheet2>",
"key_column": "<key_column>"
},
"name": "compare_sheets"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| sheet1 | Yes | ||
| sheet2 | Yes | ||
| max_diff | No | ||
| file_path | Yes | ||
| key_column | Yes | ||
| compare_columns | No |