analyzeExcelStructure
Extract Excel file structure, including sheet list and column headers, in JSON format. Specify the file path and header rows for precise data analysis and organization.
Instructions
Get Excel file structure including sheet list and column headers in JSON format
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fileAbsolutePath | Yes | The absolute path of the Excel file | |
| headerRows | No | Number of header rows to read (default: 1) |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"fileAbsolutePath": {
"description": "The absolute path of the Excel file",
"type": "string"
},
"headerRows": {
"default": 1,
"description": "Number of header rows to read (default: 1)",
"type": "number"
}
},
"required": [
"fileAbsolutePath"
],
"type": "object"
}