Excel MCP Server

by zhiwei5576
Verified

readSheetData

Extract structured data from all sheets in an Excel file, specifying start rows and header rows, using the Excel MCP Server for efficient file processing.

Instructions

Get data from all sheets in the Excel file

Input Schema

NameRequiredDescriptionDefault
dataStartRowNoThe row number to start reading data from (default: 2)
fileAbsolutePathYesThe absolute path of the Excel file
headerRowNoThe row number to use as field names (default: 1)

Input Schema (JSON Schema)

{ "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "properties": { "dataStartRow": { "default": 2, "description": "The row number to start reading data from (default: 2)", "type": "number" }, "fileAbsolutePath": { "description": "The absolute path of the Excel file", "type": "string" }, "headerRow": { "default": 1, "description": "The row number to use as field names (default: 1)", "type": "number" } }, "required": [ "fileAbsolutePath" ], "type": "object" }

You must be authenticated.

Other Tools from Excel MCP Server

Related Tools

ID: w22e5v9u5s