read_data_from_excel
Extract structured data from Excel sheets, including cell values, metadata, and validation rules. Specify file path, sheet name, and cell range to retrieve JSON-formatted data for analysis or integration.
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)
preview_only: Whether to return preview only
Returns:
JSON string containing structured cell data with validation metadata.
Each cell includes: address, value, row, column, and validation info (if any).
Input Schema
Name | Required | Description | Default |
---|---|---|---|
end_cell | No | ||
filepath | Yes | ||
preview_only | No | ||
sheet_name | Yes | ||
start_cell | No |
Input Schema (JSON Schema)
{
"properties": {
"end_cell": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "End Cell"
},
"filepath": {
"title": "Filepath",
"type": "string"
},
"preview_only": {
"default": false,
"title": "Preview Only",
"type": "boolean"
},
"sheet_name": {
"title": "Sheet Name",
"type": "string"
},
"start_cell": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Start Cell"
}
},
"required": [
"filepath",
"sheet_name"
],
"title": "read_data_from_excelArguments",
"type": "object"
}