readDataBySheetName
Extract data from a specific sheet in an Excel file by specifying the file path, sheet name, header row, and data start row for precise data retrieval.
Instructions
Get data from a specific sheet in the Excel file
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| dataStartRow | No | The row number to start reading data from (default: 2) | |
| fileAbsolutePath | Yes | The absolute path of the Excel file | |
| headerRow | No | tThe row number to use as field names (default: 1) | |
| sheetName | Yes | tThe name of the sheet to read |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"dataStartRow": {
"default": 2,
"description": "The row number to start reading data from (default: 2)",
"type": "number"
},
"fileAbsolutePath": {
"description": "The absolute path of the Excel file",
"type": "string"
},
"headerRow": {
"default": 1,
"description": "tThe row number to use as field names (default: 1)",
"type": "number"
},
"sheetName": {
"description": "tThe name of the sheet to read",
"type": "string"
}
},
"required": [
"fileAbsolutePath",
"sheetName"
],
"type": "object"
}