Elysia Tools Docs
ZH
语言
ZHESPTRUFRDEEN
返回主站
浏览工具

Format Conversion

XLSX API 写入 Sheet

将 REST/GraphQL 返回的 JSON 自动分页并映射写入 Excel Sheet

file· 文件结果打开工具

快速开始

用三种语言从你的代码中调用此工具。

cURL
curl -X POST 'https://api.elysiatools.com/zh/api/tools/xlsx-api-to-sheet' \
  -H 'Content-Type: application/json' \
  -d '{"sourceType":"rest","url":"https://elysiatools.com/zh/api/tools","method":"GET","headers":"{\"Authorization\":\"Bearer xxx\"}","queryParams":"{\"status\":\"active\"}","body":"{\"filters\":{\"status\":\"active\"}}","graphqlQuery":"query($page:Int,$limit:Int){ items(page:$page,limit:$limit){ id name } }","graphqlVariables":"{\"status\":\"active\"}","dataPath":"tools","paginationType":"none","maxPages":50,"pageParam":"page","pageStart":1,"pageSizeParam":"limit","pageSize":100,"offsetParam":"offset","offsetStart":0,"cursorParam":"cursor","cursorStart":"","hasMorePath":"data.pageInfo.hasNextPage","nextCursorPath":"pageInfo.endCursor","totalPagesPath":"meta.totalPages","fieldMapping":"{\n  \"id\": \"id\",\n  \"name\": \"name\",\n  \"category\": \"category\",\n  \"result_type\": \"resultType\",\n  \"featured\": \"featured\",\n  \"last_updated\": \"lastUpdated\"\n}","sheetName":"Tools API","outputFileName":"api-export"}'

© 2026 Elysia Tools. 开发者文档。

返回主站浏览工具

API 参考

以 JSON 形式 POST 提交输入参数。文件类型参数需先单独上传。

请求端点

HTTP
POST https://api.elysiatools.com/zh/api/tools/xlsx-api-to-sheet

请求参数

参数名类型必填说明
sourceTypeselect否—
urltext是—
methodselect否—
headerstextarea否—
queryParamstextarea否—
bodytextarea否—
graphqlQuerytextarea否—
graphqlVariablestextarea否—
dataPathtext否—
paginationTypeselect否—
maxPagesnumber否—
pageParamtext否—
pageStartnumber否—
pageSizeParamtext否—
pageSizenumber否—
offsetParamtext否—
offsetStartnumber否—
cursorParamtext否—
cursorStarttext否—
hasMorePathtext否—
nextCursorPathtext否—
totalPagesPathtext否—
fieldMappingtextarea否—
sheetNametext否—
outputFileNametext否—

响应格式

文件结果

JSON
{
  "filePath": "/public/processing/randomid.ext",
  "fileName": "output.ext",
  "contentType": "application/octet-stream",
  "size": 1024,
  "metadata": {
    "key": "value"
  },
  "error": "Error message (optional)",
  "message": "Notification message (optional)"
}

MCP 集成

将此工具加入你的 Model Context Protocol 服务，让 AI 智能体可以列出并调用它。

服务配置

将以下内容加入你的 MCP 客户端配置：

mcp.json
{
  "mcpServers": {
    "elysiatools-xlsx-api-to-sheet": {
      "name": "xlsx-api-to-sheet",
      "description": "将 REST/GraphQL 返回的 JSON 自动分页并映射写入 Excel Sheet",
      "baseUrl": "https://api.elysiatools.com/mcp/sse?toolId=xlsx-api-to-sheet",
      "command": "",
      "args": [],
      "env": {},
      "isActive": true,
      "type": "sse"
    }
  }
}

列出可用工具

连接到 SSE 端点后，列出已开放的工具：

tools/list
{
  "jsonrpc": "2.0",
  "id": 1,
  "method": "tools/list"
}

调用此工具

通过工具 id 调用，参数由其参数表构建：

tools/call
{
  "jsonrpc": "2.0",
  "id": 2,
  "method": "tools/call",
  "params": {
    "name": "xlsx-api-to-sheet",
    "arguments": {
  "sourceType": "rest",
  "url": "https://elysiatools.com/zh/api/tools",
  "method": "GET",
  "headers": "{\"Authorization\":\"Bearer xxx\"}",
  "queryParams": "{\"status\":\"active\"}",
  "body": "{\"filters\":{\"status\":\"active\"}}",
  "graphqlQuery": "query($page:Int,$limit:Int){ items(page:$page,limit:$limit){ id name } }",
  "graphqlVariables": "{\"status\":\"active\"}",
  "dataPath": "tools",
  "paginationType": "none",
  "maxPages": 50,
  "pageParam": "page",
  "pageStart": 1,
  "pageSizeParam": "limit",
  "pageSize": 100,
  "offsetParam": "offset",
  "offsetStart": 0,
  "cursorParam": "cursor",
  "cursorStart": "",
  "hasMorePath": "data.pageInfo.hasNextPage",
  "nextCursorPath": "pageInfo.endCursor",
  "totalPagesPath": "meta.totalPages",
  "fieldMapping": "{\n  \"id\": \"id\",\n  \"name\": \"name\",\n  \"category\": \"category\",\n  \"result_type\": \"resultType\",\n  \"featured\": \"featured\",\n  \"last_updated\": \"lastUpdated\"\n}",
  "sheetName": "Tools API",
  "outputFileName": "api-export"
}
  }
}
可用逗号分隔的 toolId 在一个会话中串联多个工具，例如 /mcp/sse?toolId=png-to-webp,jpg-to-webp,gif-to-webp（最多 20 个）。

有问题或反馈？请联系 [email protected]

浏览工具
打开工具