read_data_from_excel
Read Excel worksheet data with cell validation metadata, supporting custom ranges, pagination, and optional plain value grids.
Instructions
Read data from Excel worksheet with cell metadata including validation rules.
Args:
filepath: Path to Excel file
sheet_name: Name of worksheet
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.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cursor | No | ||
| compact | No | ||
| end_cell | No | ||
| filepath | Yes | ||
| max_cols | No | ||
| max_rows | No | ||
| sheet_name | Yes | ||
| start_cell | No | A1 | |
| values_only | No | ||
| preview_only | No |