excel_tool
Read, write, and convert JSON to Excel/CSV files using a modular automation tool in the ToolBox MCP Server. Manage file formats, stream large datasets, and customize options for efficient data handling.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| action | Yes | Action to perform: read, write, or convert_json_to_xlsx | |
| chunkSize | No | Chunk size (rows) for streaming | |
| data | No | Data to write (required for write action) | |
| filePath | Yes | Absolute path to the file | |
| format | Yes | File format: xlsx, xls, csv | |
| options | No | Additional options | |
| stream | No | Enable streaming for large files |
Input Schema (JSON Schema)
{
"description": "Read and write Excel/CSV files",
"name": "excel_tool",
"properties": {
"action": {
"description": "Action to perform: read, write, or convert_json_to_xlsx",
"enum": [
"read",
"write",
"convert_json_to_xlsx"
],
"type": "string"
},
"chunkSize": {
"default": 1000,
"description": "Chunk size (rows) for streaming",
"type": "number"
},
"data": {
"description": "Data to write (required for write action)",
"items": {
"additionalProperties": true,
"type": "object"
},
"type": "array"
},
"filePath": {
"description": "Absolute path to the file",
"type": "string"
},
"format": {
"description": "File format: xlsx, xls, csv",
"enum": [
"xlsx",
"xls",
"csv"
],
"type": "string"
},
"options": {
"additionalProperties": true,
"description": "Additional options",
"properties": {
"headerRow": {
"description": "Include header row in output",
"type": "boolean"
},
"sheetName": {
"description": "Sheet name for Excel files",
"type": "string"
}
},
"type": "object"
},
"stream": {
"default": false,
"description": "Enable streaming for large files",
"type": "boolean"
}
},
"required": [
"action",
"filePath",
"format"
],
"type": "object"
}