read_data_from_excel
Extract structured data from Excel worksheets, including cell values, addresses, and validation rules, in JSON format. Specify filepath, sheet name, and optional cell range for precise data retrieval.
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 | A1 |
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": {
"default": "A1",
"title": "Start Cell",
"type": "string"
}
},
"required": [
"filepath",
"sheet_name"
],
"title": "read_data_from_excelArguments",
"type": "object"
}