writeDataBySheetName
Write or overwrite data to a specific sheet in an Excel file by providing the file path, sheet name, and data array. Simplifies Excel file updates programmatically.
Instructions
Write data to a specific sheet in the Excel file (overwrites if sheet exists)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | Array of objects to write to the sheet | |
| fileAbsolutePath | Yes | The absolute path of the Excel file | |
| sheetName | Yes | The name of the sheet to write |
Input Schema (JSON Schema)
{
"$schema": "http://json-schema.org/draft-07/schema#",
"additionalProperties": false,
"properties": {
"data": {
"description": "Array of objects to write to the sheet",
"items": {
"additionalProperties": {},
"type": "object"
},
"type": "array"
},
"fileAbsolutePath": {
"description": "The absolute path of the Excel file",
"type": "string"
},
"sheetName": {
"description": "The name of the sheet to write",
"type": "string"
}
},
"required": [
"fileAbsolutePath",
"sheetName",
"data"
],
"type": "object"
}