get_sheet_values
Get cell values from a Feishu spreadsheet by providing its token and a data range.
Instructions
获取飞书电子表格的数据
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| spreadsheet_token | Yes | 电子表格Token | |
| range_ | Yes | 数据范围（如 Sheet1!A1:D10） |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |
Implementation Reference
- src/feishu_mcp_server/server.py:188-202 (handler)MCP tool handler function for 'get_sheet_values'. Decorated with @mcp.tool(), it receives spreadsheet_token and range_, calls client.get_sheet_values(), and returns the result as JSON.
@mcp.tool() def get_sheet_values(spreadsheet_token: str, range_: str) -> str: """获取飞书电子表格的数据 Args: spreadsheet_token: 电子表格Token range_: 数据范围（如 Sheet1!A1:D10） """ if not config.enable_sheet: return json.dumps({"error": "电子表格功能未启用"}, ensure_ascii=False) try: result = client.get_sheet_values(spreadsheet_token, range_) return json.dumps(result, ensure_ascii=False, indent=2, default=str) except Exception as e: return json.dumps({"error": str(e)}, ensure_ascii=False) - Client method that executes the actual Feishu API request to GET /sheets/v2/spreadsheets/{token}/values/{range_} to retrieve sheet cell values.
def get_sheet_values(self, spreadsheet_token: str, range_: str) -> dict[str, Any]: """获取电子表格数据""" return self._request( "GET", f"/sheets/v2/spreadsheets/{spreadsheet_token}/values/{range_}" ) - src/feishu_mcp_server/server.py:188-188 (registration)Registration via @mcp.tool() decorator on the get_sheet_values function in server.py.
@mcp.tool() - tests/test_server.py:72-72 (schema)Test assertion verifying 'get_sheet_values' is registered as a tool name in the MCP server.
"list_sheets", "get_sheet_values",