excel_write_to_sheet
Write data to Excel sheets efficiently by specifying file path, sheet name, cell range, and values. Supports new sheet creation and formula input.
Instructions
Write values to the Excel sheet
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fileAbsolutePath | Yes | Absolute path to the Excel file | |
| newSheet | Yes | Create a new sheet if true, otherwise write to the existing sheet | |
| range | Yes | Range of cells in the Excel sheet (e.g., "A1:C10") | |
| sheetName | Yes | Sheet name in the Excel file | |
| values | Yes | Values to write to the Excel sheet. If the value is a formula, it should start with "=" |
Input Schema (JSON Schema)
{
"properties": {
"fileAbsolutePath": {
"description": "Absolute path to the Excel file",
"type": "string"
},
"newSheet": {
"description": "Create a new sheet if true, otherwise write to the existing sheet",
"type": "boolean"
},
"range": {
"description": "Range of cells in the Excel sheet (e.g., \"A1:C10\")",
"type": "string"
},
"sheetName": {
"description": "Sheet name in the Excel file",
"type": "string"
},
"values": {
"description": "Values to write to the Excel sheet. If the value is a formula, it should start with \"=\"",
"items": {
"items": {
"anyOf": [
{
"type": "string"
},
{
"type": "number"
},
{
"type": "boolean"
},
{
"type": "null"
}
]
},
"type": "array"
},
"type": "array"
}
},
"required": [
"fileAbsolutePath",
"sheetName",
"newSheet",
"range",
"values"
],
"type": "object"
}