read_excel
Extract and convert Excel file data into a string for analysis or processing. Specify file path, sheet name, row limit, and header row to customize the output.
Instructions
Read an Excel file and return its contents as a string.
Args:
file_path: Path to the Excel file
sheet_name: Name of the sheet to read (only for .xlsx, .xls)
nrows: Maximum number of rows to read
header: Row to use as header (0-indexed)
Returns:
String representation of the Excel data
Input Schema
Name | Required | Description | Default |
---|---|---|---|
file_path | Yes | ||
header | No | ||
nrows | No | ||
sheet_name | No |
Input Schema (JSON Schema)
{
"properties": {
"file_path": {
"title": "File Path",
"type": "string"
},
"header": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": 0,
"title": "Header"
},
"nrows": {
"anyOf": [
{
"type": "integer"
},
{
"type": "null"
}
],
"default": null,
"title": "Nrows"
},
"sheet_name": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Sheet Name"
}
},
"required": [
"file_path"
],
"title": "read_excelArguments",
"type": "object"
}