read_data_from_excel

Extract structured data from Excel sheets, including cell values, metadata, and validation rules. Specify file path, sheet name, and cell range to retrieve JSON-formatted data for analysis or integration.

Instructions

Read data from Excel worksheet with cell metadata including validation rules.

Args:
    filepath: Path to Excel file
    sheet_name: Name of worksheet
    start_cell: Starting cell (default A1)
    end_cell: Ending cell (optional, auto-expands if not provided)
    preview_only: Whether to return preview only

Returns:  
JSON string containing structured cell data with validation metadata.
Each cell includes: address, value, row, column, and validation info (if any).

Input Schema

Name	Required	Description	Default
`end_cell`	No
`filepath`	Yes
`preview_only`	No
`sheet_name`	Yes
`start_cell`	No

Input Schema (JSON Schema)

{
  "properties": {
    "end_cell": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "End Cell"
    },
    "filepath": {
      "title": "Filepath",
      "type": "string"
    },
    "preview_only": {
      "default": false,
      "title": "Preview Only",
      "type": "boolean"
    },
    "sheet_name": {
      "title": "Sheet Name",
      "type": "string"
    },
    "start_cell": {
      "anyOf": [
        {
          "type": "string"
        },
        {
          "type": "null"
        }
      ],
      "default": null,
      "title": "Start Cell"
    }
  },
  "required": [
    "filepath",
    "sheet_name"
  ],
  "title": "read_data_from_excelArguments",
  "type": "object"
}

xlwings Excel MCP Server

read_data_from_excel

Instructions

Input Schema

Input Schema (JSON Schema)

Other Tools from xlwings Excel MCP Server

Related Tools

MCP directory API