write_excel
Convert and save CSV or JSON data into an Excel file, specifying the file path, sheet name, and format. Ideal for organizing and exporting structured data into spreadsheets.
Instructions
Write data to an Excel file.
Args:
file_path: Path to save the Excel file
data: Data in CSV or JSON format
sheet_name: Name of the sheet (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": "write_excelArguments",
"type": "object"
}