Excel MCP Server

by zhiwei5576
Verified

writeSheetData

Generate and save a new Excel file by inputting structured data and specifying the file path. Ideal for automating spreadsheet creation within the Excel MCP Server environment.

Instructions

Create a new Excel file with provided data

Input Schema

NameRequiredDescriptionDefault
dataYesData object with dynamic sheet names and column names
fileAbsolutePathYesThe absolute path for the new Excel file

Input Schema (JSON Schema)

{ "$schema": "http://json-schema.org/draft-07/schema#", "additionalProperties": false, "properties": { "data": { "additionalProperties": { "items": { "additionalProperties": {}, "type": "object" }, "type": "array" }, "description": "Data object with dynamic sheet names and column names", "type": "object" }, "fileAbsolutePath": { "description": "The absolute path for the new Excel file", "type": "string" } }, "required": [ "fileAbsolutePath", "data" ], "type": "object" }

You must be authenticated.

Other Tools from Excel MCP Server

Related Tools

ID: w22e5v9u5s