update_excel
Modify existing Excel files by adding or replacing data in specified sheets using CSV or JSON formats. Automate file updates efficiently with clear input parameters.
Instructions
Update an existing Excel file with new data.
Args:
file_path: Path to the Excel file to update
data: New data in CSV or JSON format
sheet_name: Name of the sheet to update (for Excel files)
format: Format of the input data ('csv' or 'json')
Returns:
Confirmation message
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | Yes | ||
| file_path | Yes | ||
| format | No | csv | |
| sheet_name | No | Sheet1 |
Input Schema (JSON Schema)
{
"properties": {
"data": {
"title": "Data",
"type": "string"
},
"file_path": {
"title": "File Path",
"type": "string"
},
"format": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": "csv",
"title": "Format"
},
"sheet_name": {
"anyOf": [
{
"type": "string"
},
{
"type": "null"
}
],
"default": "Sheet1",
"title": "Sheet Name"
}
},
"required": [
"file_path",
"data"
],
"title": "update_excelArguments",
"type": "object"
}