join_sheets
Join two Excel sheets using SQL-like join keys (left, right, inner, outer). Specify columns to return and row limit for efficient data merging.
Instructions
关联两个工作表(类似 SQL JOIN),只回传前 limit 行结果。
参数:
on:关联键列名(两表都要有)
how:left / right / inner / outer(默认 left)
columns:只返回这些列(省 token),省略返回全部
limit:返回行数上限(默认 20)
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>",
"left_sheet": "<left_sheet>",
"right_sheet": "<right_sheet>",
"on": "<on>"
},
"name": "join_sheets"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| on | Yes | ||
| how | No | left | |
| limit | No | ||
| columns | No | ||
| file_path | Yes | ||
| left_sheet | Yes | ||
| right_sheet | Yes |