Excel MCP Server

MIT License

439

Overview InspectNew Endpoints Schema Related Servers Reviews Score

writeDataBySheetName

Write or overwrite data to a specific sheet in an Excel file by providing the file path, sheet name, and data array. Simplifies Excel file updates programmatically.

Instructions

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

Input Schema

Name	Required	Description
`data`	Yes	Array of objects to write to the sheet
`fileAbsolutePath`	Yes	The absolute path of the Excel file
`sheetName`	Yes	The 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"
}

This server cannot be installed

Other Tools from Excel MCP Server

Related Tools

excel_write_to_sheet
@negokaz/excel-mcp-server
write_data_to_excel
@hyunjae-labs/xlwings-mcp-server
update_excel
@yzfly/mcp-excel-server
write_data_to_excel
@haris-musa/excel-mcp-server
set_cell_value
@SuperPyonchiX/excel_mcp_server
add_formula
@SuperPyonchiX/excel_mcp_server

MCP directory API

We provide all the information about MCP servers via our MCP API.

curl -X GET 'https://glama.ai/api/mcp/v1/servers/zhiwei5576/excel-mcp-server'

If you have feedback or need assistance with the MCP directory API, please join our Discord server