wps_excel_generate_formula

根据自然语言描述生成Excel公式。这是解决用户"公式不会写"痛点的核心工具。使用场景： - 用户说"帮我写个公式查价格" -> 生成 VLOOKUP/XLOOKUP - 用户说"如果大于100就显示达标" -> 生成 IF 公式 - 用户说"统计每个部门的人数" -> 生成 COUNTIF - 用户说"求这列的平均值" -> 生成 AVERAGE 调用此工具会返回当前工作表的上下文信息，包括表头、选中区域等，便于生成准确的公式。

SERVERWps Office SOURCEwps-office-mcp

Medium RISK CLASS

Category Write

Parameters 21 required

Recommended Rate-limitedsee the rule below

Registry record Grade F, identity unverified Pull the record →

This record as markdown: /tools/wps-office-mcp/wps-excel-generate-formula.md

WHAT IT DOES

What wps_excel_generate_formula does on Wps Office

AI agents use wps_excel_generate_formula to create or update resources in Wps Office, usually the action step of a workflow, after the agent has gathered context. Every call changes real data in your Wps Office environment.

Parameter	Type	Required	Description
`description`	string	Yes	用户对公式需求的自然语言描述，如"查找产品名对应的价格"、"计算A列的总和"
`target_cell`	string	—	目标单元格地址，如 B2。不填则返回上下文让用户确认

Parameters from the server's own tool schema.

RISK

Why wps_excel_generate_formula is rated Medium

An AI agent can call wps_excel_generate_formula faster than any human can review: one bad instruction and it creates or modifies resources in Wps Office by the hundred, each call as confident as the last.

Attacks that exploit this kind of access

RECOMMENDED RULE

The rule that runs wps_excel_generate_formula safely

PolicyLayer is an MCP gateway: it sits between your AI agents and Wps Office, and checks every tool call against a rule you set before the call runs. Nothing changes on the server itself. For wps_excel_generate_formula, this is the rule to start with:

wps_excel_generate_formula Rate-limited

wps_excel_generate_formula stays usable, but capped: an agent stuck in a loop can't make hundreds of changes a minute. Everything else on the server is denied unless you say otherwise.

View as policy code

policy.json

{
  "version": "1",
  "default": "deny",
  "tools": {
    "wps_excel_generate_formula": {
      "limits": [
        {
          "counter": "wps_excel_generate_formula_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}

LIMIT THIS TOOL → Instant setup, no code required.

The button opens the PolicyLayer dashboard: create your workspace, connect Wps Office, apply this rule, and every wps_excel_generate_formula call is checked against it from then on.

FAQ

Questions about wps_excel_generate_formula

What does the wps_excel_generate_formula tool do? +

What parameters does wps_excel_generate_formula accept? +

wps_excel_generate_formula accepts 2 parameters: description, target_cell. Required: description. The full parameter table on this page comes from the server's own tool schema.

How do I enforce a policy on wps_excel_generate_formula? +

Register the Wps Office MCP server in PolicyLayer and add a rule for wps_excel_generate_formula: allow, deny, rate-limit, or require approval. Point your MCP client at the PolicyLayer proxy URL and the rule is enforced on every call, before it reaches Wps Office. Nothing to install.

What risk level is wps_excel_generate_formula? +

wps_excel_generate_formula is a Write tool with medium risk. Write tools should be rate-limited to prevent accidental bulk modifications.

Can I rate-limit wps_excel_generate_formula? +

Yes. Add a rate_limit block to the wps_excel_generate_formula rule in your PolicyLayer policy. For example, setting max: 10 and window: 60 limits the tool to 10 calls per minute. Rate limits are tracked per agent session and reset automatically.

How do I block wps_excel_generate_formula completely? +

Set action: deny in the PolicyLayer policy for wps_excel_generate_formula. The AI agent will receive a policy violation error and cannot call the tool. You can also include a reason field to explain why the tool is blocked.

What MCP server provides wps_excel_generate_formula? +

wps_excel_generate_formula is provided by the Wps Office MCP server (wps-office-mcp). PolicyLayer sits as a proxy in front of this server to enforce policies before tool calls reach the server.

KEEP EXPLORING

More on Wps Office, and thousands of servers like it.

This server

All 250 Wps Office tools →

Across the catalogue

generate_commit on MCP Server PR Pilot →generate_summary on ACE-MCP →generate_video_title on YouTube MCP Server →generate_devtools_report on Percepta MCP Server → The MCP Attack Database →

Guides

Govern customer-ops agents →Argument validation →Scoped token →