read_data_from_excel

Extract structured data, including cell values and validation metadata, from Excel worksheets using specified file paths, sheet names, and cell ranges. Returns JSON for easy integration and analysis.

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