writeSheetData
Generate a new Excel file using structured data by specifying file path and dynamic sheet-column configurations for efficient worksheet management.
Instructions
Create a new Excel file with provided data
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | Data object with dynamic sheet names and column names | |
| fileAbsolutePath | Yes | The absolute path for the new Excel file |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"data": {
"additionalProperties": {
"items": {
"additionalProperties": {},
"type": "object"
},
"type": "array"
},
"description": "Data object with dynamic sheet names and column names",
"type": "object"
},
"fileAbsolutePath": {
"description": "The absolute path for the new Excel file",
"type": "string"
}
},
"required": [
"fileAbsolutePath",
"data"
],
"type": "object"
}