Skip to main content
Glama
Sign In
enesjakozh

Excel MCP Server

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

writeDataBySheetName

Write data to a specific sheet in an Excel file, overwriting existing content if the sheet is present. Requires file path, sheet name, and data array for accurate execution.

Instructions

Write data to a specific sheet in the Excel file (overwrites if sheet exists)

Input Schema

NameRequiredDescriptionDefault
dataYesArray of objects to write to the sheet
fileAbsolutePathYesThe absolute path of the Excel file
sheetNameYesThe name of the sheet to write

Input Schema (JSON Schema)

{ "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "properties": { "data": { "description": "Array of objects to write to the sheet", "items": { "additionalProperties": {}, "type": "object" }, "type": "array" }, "fileAbsolutePath": { "description": "The absolute path of the Excel file", "type": "string" }, "sheetName": { "description": "The name of the sheet to write", "type": "string" } }, "required": [ "fileAbsolutePath", "sheetName", "data" ], "type": "object" }

You must be authenticated.

Other Tools from Excel MCP Server

Related Tools

ID: w22e5v9u5s