write_data_to_excel
Write structured data to an Excel worksheet with specified file path, sheet name, and starting cell. Supports direct data insertion without verification for efficient worksheet updates.
Instructions
Write data to Excel worksheet.
Excel formula will write to cell without any verification.
PARAMETERS:
filepath: Path to Excel file
sheet_name: Name of worksheet to write to
data: List of lists containing data to write to the worksheet, sublists are assumed to be rows
start_cell: Cell to start writing to (optional, auto-finds appropriate location)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | ||
| filepath | Yes | ||
| sheet_name | Yes | ||
| start_cell | No |
Input Schema (JSON Schema)
{
"properties": {
"data": {
"items": {
"items": {},
"type": "array"
},
"title": "Data",
"type": "array"
},
"filepath": {
"title": "Filepath",
"type": "string"
},
"sheet_name": {
"title": "Sheet Name",
"type": "string"
},
"start_cell": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": null,
"title": "Start Cell"
}
},
"required": [
"filepath",
"sheet_name",
"data"
],
"title": "write_data_to_excelArguments",
"type": "object"
}