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
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| file_path | Yes | ||
| table_name | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||