get_table_data
Retrieve rows and headers from a named Excel table by providing the file path and table name.
Instructions
Return data from a named Excel table.
table_name: the display name of the table (from list_tables)
Returns a dict with:
table: table name
sheet: sheet the table lives on
ref: cell range
headers: first row (column headers)
rows: remaining rows as list of lists
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>",
"table_name": "<table_name>"
},
"name": "get_table_data"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| table_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||