write_data_to_excel
Write structured data directly to an Excel worksheet. Specify filepath, sheet name, data (as nested lists), and starting cell to populate Excel efficiently.
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, default is "A1"
Input Schema
Name | Required | Description | Default |
---|---|---|---|
data | Yes | ||
filepath | Yes | ||
sheet_name | Yes | ||
start_cell | No | A1 |
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": {
"default": "A1",
"title": "Start Cell",
"type": "string"
}
},
"required": [
"filepath",
"sheet_name",
"data"
],
"title": "write_data_to_excelArguments",
"type": "object"
}