read_data_from_excel
Read-only
Reads data from a specified Excel worksheet, including cell metadata and validation rules, or a plain value grid, so AI agents can inspect spreadsheet ranges without Excel.
Instructions
Read data from Excel worksheet with cell metadata including validation rules.
Args:
filepath: Path to Excel file
sheet_name: Worksheet tab name, NOT a native table name; list_tables maps tables to tabs
start_cell: Starting cell (default A1)
end_cell: Ending cell (optional, auto-expands if not provided)
max_rows: Optional maximum number of rows to return from the starting row
max_cols: Optional maximum number of columns to return from the starting column
cursor: Optional continuation token returned by an earlier range read
preview_only: Whether to return preview only
compact: Whether to omit default validation metadata for smaller responses
values_only: Whether to return a 2D value grid without per-cell metadata
Returns:
JSON string containing either structured cell data with validation metadata
or a plain 2D value grid when values_only=True.
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": {
"filepath": "<filepath>",
"sheet_name": "<sheet_name>"
},
"name": "read_data_from_excel"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cursor | No | ||
| compact | No | ||
| end_cell | No | ||
| filepath | Yes | Reuse supplied server path; NEVER prepend client cwd. Rooted: relative OK; unrooted stdio: absolute, ask if missing. | |
| max_cols | No | ||
| max_rows | No | ||
| sheet_name | Yes | ||
| start_cell | No | A1 | |
| values_only | No | ||
| preview_only | No |