excel_tool

excel_tool

Input Schema

Name	Required	Description
`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"
}

Input Schema

Input Schema (JSON Schema)

Other Tools