Skip to main content
Glama
Sign In
office-mcp-server

office-mcp-server

by jiahuidegit
OverviewSchemaSourceRelated ServersDiscussionsAdmin
TypeScript
Local

excel_add_chart

Writes chart data to a specific cell in an Excel worksheet, including categories and series, so you can create the chart manually in Excel.

Instructions

写入图表数据到指定位置（exceljs 不支持直接创建图表对象，数据写入后可在 Excel 中手动创建图表）

Tool call template

Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.

{
  "id": 1,
  "jsonrpc": "2.0",
  "method": "tools/call",
  "params": {
    "arguments": {
      "workbookId": "<workbookId>",
      "sheetName": "<sheetName>",
      "chartType": "<chartType>",
      "categories": "<categories>",
      "series": "<series>"
    },
    "name": "excel_add_chart"
  }
}

Input Schema

NameRequiredDescriptionDefault
titleNo图表标题
seriesYes数据系列
positionNo图表位置，如 F2
chartTypeYes图表类型
sheetNameYes工作表名称
categoriesYes分类标签
workbookIdYes工作簿ID

Schema Changelog

Changes observed during successful MCP inspections.

  1. First observedv0.4.1

TDQS

A4.2/5.0
Behavior4/5

Does the description disclose side effects, auth requirements, rate limits, or destructive behavior?

The description discloses the key limitation that exceljs does not support direct chart object creation, which is not conveyed by annotations. This helps the agent set expectations. Annotations already indicate write-only (readOnlyHint=false), consistent with the description.

Agents need to know what a tool does to the world before calling it. Descriptions should go beyond structured annotations to explain consequences.

Conciseness5/5

Is the description appropriately sized, front-loaded, and free of redundancy?

The description is a single sentence with a parenthetical clarification, efficiently conveying the core function and limitation without redundancy.

Shorter descriptions cost fewer tokens and are easier for agents to parse. Every sentence should earn its place.

Completeness4/5

Given the tool's complexity, does the description cover enough for an agent to succeed on first attempt?

The description covers the essential behavior and limitation, and with the schema covering parameters, it is sufficiently complete for a write tool, though it could specify the layout of written data if needed.

Complex tools with many parameters or behaviors need more documentation. Simple tools need less. This dimension scales expectations accordingly.

Parameters3/5

Does the description clarify parameter syntax, constraints, interactions, or defaults beyond what the schema provides?

Schema descriptions cover all 7 parameters (100% coverage), so the description does not need to add parameter details. It adds no additional explanation beyond what the schema provides, so baseline 3 is appropriate.

Input schemas describe structure but not intent. Descriptions should explain non-obvious parameter relationships and valid value ranges.

Purpose5/5

Does the description clearly state what the tool does and how it differs from similar tools?

The description explicitly states '写入图表数据到指定位置' (write chart data to specified position), and clarifies that exceljs does not support direct chart creation, clearly distinguishing this from other Excel tools that create charts or write general data. The verb and resource are specific and the limitation is mentioned.

Agents choose between tools based on descriptions. A clear purpose with a specific verb and resource helps agents select the right tool.

Usage Guidelines4/5

Does the description explain when to use this tool, when not to, or what alternatives exist?

The description provides clear context by stating that after data is written, users must manually create charts in Excel, implying this tool is for preparing chart data rather than generating chart objects. It doesn't explicitly name alternatives but gives enough context for when to use it.

Agents often have multiple tools that could apply. Explicit usage guidance like "use X instead of Y when Z" prevents misuse.

Deploy Server

Other Tools