# wps_excel_create_pivot_table

创建Excel透视表，用于数据汇总和分析。 使用场景： - "帮我按部门统计销售额" -> 行字段=部门，值字段=销售额(SUM) - "按月份和产品分析数量" -> 行字段=月份，列字段=产品，值字段=数量(SUM) - "统计各地区的订单数" -> 行字段=地区，值字段=订单号(COUNT) 注意事项： - sourceRange必须包含表头行 - rowFields、columnFields、valueFields中的field必须是表头中的列名 - 透视表会从destinationCell开始向右下方扩展

Agent View of the PolicyLayer registry record for `wps_excel_create_pivot_table`. HTML page: https://policylayer.com/tools/wps-office-mcp/wps-excel-create-pivot-table

## Facts

- Tool: `wps_excel_create_pivot_table`
- Server: Wps Office (`wps-office-mcp`) — https://policylayer.com/tools/wps-office-mcp.md
- Install: `npx -y wps-office-mcp`
- Homepage: https://www.npmjs.com/package/wps-office-mcp
- Risk category: Write (Medium risk)
- Registry record: grade F, identity unverified
- Server rate-limited: no
- Parameters: 8 (4 required)
- Recommended policy verdict: Rate-limited

## Parameters

| Parameter | Type | Required | Description |
| --- | --- | --- | --- |
| `rowFields` | array | yes | 行字段列名列表，如["部门", "员工"]。这些字段会作为透视表的行标签 |
| `tableName` | string | no | 透视表名称（可选），不填则自动生成 |
| `sourceRange` | string | yes | 数据源范围，如"A1:E100"。必须包含表头行，数据要连续无空行 |
| `valueFields` | array | yes | 值字段配置列表。每项包含field(字段名)和aggregation(聚合方式:SUM/COUNT/AVERAGE/MAX/MIN) |
| `columnFields` | array | no | 列字段列名列表（可选），如["月份"]。这些字段会作为透视表的列标签 |
| `filterFields` | array | no | 筛选字段列名列表（可选），这些字段会出现在透视表上方作为筛选器 |
| `destinationCell` | string | yes | 透视表放置位置（左上角单元格），如"G1"、"H5" |
| `destinationSheet` | string | no | 目标工作表名称（可选），透视表将创建在此工作表，不填则使用当前工作表 |

Parameters from the server's own tool schema.

## Example call (MCP tools/call, JSON-RPC 2.0)

```json
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/call",
  "params": {
    "name": "wps_excel_create_pivot_table",
    "arguments": {
      "rowFields": [],
      "sourceRange": "<sourceRange>",
      "valueFields": [],
      "destinationCell": "<destinationCell>"
    }
  }
}
```

## Why wps_excel_create_pivot_table is rated Medium

An AI agent can call wps_excel_create_pivot_table 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.

Risk signals: High parameter count (10 properties)

## Use case

AI agents use wps_excel_create_pivot_table 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.

## Recommended policy (PolicyLayer)

Verdict: **Rate-limited**. Enforced by the PolicyLayer MCP gateway (https://policylayer.com/mcp-gateway) before a call reaches Wps Office:

```json
{
  "version": "1",
  "default": "deny",
  "tools": {
    "wps_excel_create_pivot_table": {
      "limits": [
        {
          "counter": "wps_excel_create_pivot_table_rate",
          "window": "minute",
          "max": 30,
          "scope": "grant"
        }
      ]
    }
  }
}
```

## Other tools on Wps Office (249)

- `wps_clear_cache` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-clear-cache.md
- `wps_excel_clear_range` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-excel-clear-range.md
- `wps_excel_delete_cell_comment` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-excel-delete-cell-comment.md
- `wps_excel_delete_column` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-excel-delete-column.md
- `wps_excel_delete_columns` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-excel-delete-columns.md
- `wps_excel_delete_row` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-excel-delete-row.md
- `wps_excel_delete_rows` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-excel-delete-rows.md
- `wps_excel_delete_sheet` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-excel-delete-sheet.md
- `wps_excel_remove_duplicates` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-excel-remove-duplicates.md
- `wps_ppt_add_animation_preset` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-ppt-add-animation-preset.md
- `wps_ppt_delete_ppt_image` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-ppt-delete-ppt-image.md
- `wps_ppt_delete_shape` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-ppt-delete-shape.md
- `wps_ppt_delete_slide` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-ppt-delete-slide.md
- `wps_ppt_delete_textbox` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-ppt-delete-textbox.md
- `wps_ppt_remove_animation` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-ppt-remove-animation.md
- `wps_ppt_remove_ppt_hyperlink` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-ppt-remove-ppt-hyperlink.md
- `wps_ppt_remove_slide_transition` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-ppt-remove-slide-transition.md
- `wps_ppt_set_slide_transition` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-ppt-set-slide-transition.md
- `wps_ppt_set_transition` — Destructive — https://policylayer.com/tools/wps-office-mcp/wps-ppt-set-transition.md
- `wps_execute_method` — Execute — https://policylayer.com/tools/wps-office-mcp/wps-execute-method.md
- `wps_ppt_start_slide_show` — Execute — https://policylayer.com/tools/wps-office-mcp/wps-ppt-start-slide-show.md
- `wps_cache_data` — Read — https://policylayer.com/tools/wps-office-mcp/wps-cache-data.md
- `wps_check_connection` — Read — https://policylayer.com/tools/wps-office-mcp/wps-check-connection.md
- `wps_common_get_app_info` — Read — https://policylayer.com/tools/wps-office-mcp/wps-common-get-app-info.md
- `wps_common_get_selected_text` — Read — https://policylayer.com/tools/wps-office-mcp/wps-common-get-selected-text.md
- `wps_common_wire_check` — Read — https://policylayer.com/tools/wps-office-mcp/wps-common-wire-check.md
- `wps_excel_clean_data` — Read — https://policylayer.com/tools/wps-office-mcp/wps-excel-clean-data.md
- `wps_excel_find_replace` — Read — https://policylayer.com/tools/wps-office-mcp/wps-excel-find-replace.md
- `wps_excel_get_cell_comments` — Read — https://policylayer.com/tools/wps-office-mcp/wps-excel-get-cell-comments.md
- `wps_excel_get_cell_info` — Read — https://policylayer.com/tools/wps-office-mcp/wps-excel-get-cell-info.md
- …and 219 more: https://policylayer.com/tools/wps-office-mcp.md

## For agents

This record is a snapshot. Live verdicts and the full registry:

- Check every server in your MCP config at once: `npx -y policylayer stack`
- Vet a server before you add it: install the mcp-precheck skill — `npx skills add https://policylayer.com` (skill text: https://policylayer.com/skill.md)
- Query the registry over MCP: endpoint `https://api.policylayer.com/mcp` — tools `check_mcp_server`, `check_mcp_stack`, `check_tool`, `search_registry`, `get_change_events`

---

Source: the PolicyLayer MCP registry — one continuously verified record per MCP server. Full record: https://policylayer.com/registry?q=wps-office-mcp · API: https://policylayer.com/registry/api · Policy library: https://policylayer.com/policies/wps-office-mcp