Skip to main content
Glama
Sign In
enesjakozh

Excel MCP Server

by zhiwei5576
npmGitHub
TypeScript
MIT License
212
11
  • Linux
  • Apple
OverviewInspectNewSchemaRelated ServersReviewsScore
Need Help?View Source CodeReport Issue

readDataBySheetName

Extract data from a specified sheet in an Excel file by providing the file path, sheet name, and optional row configurations. Ideal for structured data retrieval and analysis.

Instructions

Get data from a specific sheet in the Excel file

Input Schema

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

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": "tThe row number to use as field names (default: 1)", "type": "number" }, "sheetName": { "description": "tThe name of the sheet to read", "type": "string" } }, "required": [ "fileAbsolutePath", "sheetName" ], "type": "object" }

You must be authenticated.

Other Tools from Excel MCP Server

Related Tools

ID: w22e5v9u5s