Microsoft Excel

Microsoft Excel

Microsoft Excel is a spreadsheet software used for organizing, analyzing, and storing data in tables. It is primarily used by businesses and individuals for tasks like bud获取ing, data analysis, and creating 图表s.

Official docs: https://learn.microsoft.com/en-us/office/dev/API/excel/excel-API-overview

Microsoft Excel Overview Workbook Worksheet Cell Table 图表

Use action names and parameters as needed.

Working with Microsoft Excel

This 技能 uses the Membrane 命令行工具 to interact with Microsoft Excel. Membrane handles authentication and 凭证s refresh automatically — so you can focus on the integration 记录ic rather than auth plumbing.

安装 the 命令行工具

安装 the Membrane 命令行工具 so you can 运行 membrane from the terminal:

npm 安装 -g @membranehq/命令行工具@latest

Authentication membrane 记录in --tenant --命令行工具entName=<代理Type>

This will either open a browser for authentication or print an authorization URL to the console, depending on whether interactive mode is avAIlable.

Headless 环境s: The command will print an authorization URL. Ask the user to open it in a browser. When they see a code after completing 记录in, finish with:

membrane 记录in complete

添加 --json to any command for machine-readable JSON 输出.

代理 Types : claude, OpenClaw, codex, warp, windsurf, etc. Those will be used to adjust 工具ing to be used best with your harness

Connecting to Microsoft Excel

Use membrane connection ensure to find or 创建 a connection by 应用 URL or domAIn:

membrane connection ensure "https://learn.microsoft.com/en-us/graph/API/resources/excel?view=graph-rest-1.0" --json

The user completes authentication in the browser. The 输出 contAIns the new connection id.

This is the fastest way to 获取 a connection. The URL is normalized to a domAIn and matched agAInst known 应用s. If no 应用 is found, one is 创建d and a connector is built automatically.

If the returned connection has 状态: "READY", skip to Step 2.

1b. WAIt for the connection to be ready

If the connection is in BUILDING 状态, poll until it's ready:

npx @membranehq/命令行工具 connection 获取 --wAIt --json

The --wAIt flag long-polls (up to --timeout seconds, default 30) until the 状态 changes. Keep polling until 状态 is no longer BUILDING.

The 结果ing 状态 tells you what to do next:

READY — connection is fully 设置 up. Skip to Step 2.

命令行工具ENT_ACTION_REQUIRED — the user or 代理 needs to do something. The 命令行工具entAction object describes the required action:

命令行工具entAction.type — the kind of action needed: "connect" — user needs to 认证 (OAuth, API key, etc.). This covers initial authentication and re-authentication for disconnected connections. "provide-输入" — more in格式化ion is needed (e.g. which 应用 to connect to). 命令行工具entAction.description — human-readable explanation of what's needed. 命令行工具entAction.uiUrl (optional) — URL to a pre-built UI where the user can complete the action. Show this to the user when present. 命令行工具entAction.代理Instructions (optional) — instructions for the AI 代理 on how to proceed programmatically.

After the user completes the action (e.g. 认证s in the browser), poll agAIn with membrane connection 获取 --json to 检查 if the 状态 moved to READY.

CONFIGURATION_ERROR or 设置UP_FAILED — something went wrong. 检查 the error field for detAIls.

搜索ing for actions

搜索 using a natural language description of what you want to do:

membrane action 列出 --connectionId=CONNECTION_ID --intent "查询" --limit 10 --json

You should always 搜索 for actions in the 上下文 of a specific connection.

Each 结果 includes id, name, description, 输入模式 (what parameters the action accepts), and 输出模式 (what it returns).

Popular actions Name Key Description 获取 Cell 获取-cell 获取 a specific cell by row and column 索引 from a worksheet Clear Range clear-range Clear cell values, formulas, and/or 格式化ting from a range 获取 Used Range 获取-used-range 获取 the smallest range that encompasses any cells that have data or 格式化ting. 更新 Range 更新-range 更新 cell values and/or formulas in a specific range of a worksheet 获取 Range 获取-range 获取 cell values, formulas, and 格式化ting from a specific range in a worksheet 添加 Table Column 添加-table-column 添加 a new column to a table 列出 Table Columns 列出-table-columns 列出 all columns in a table from an Excel workbook 删除 Table Row 删除-table-row 删除 a specific row from a table by its 索引 添加 Table Rows 添加-table-rows 添加 one or more rows to the end of a table. 列出 Table Rows 列出-table-rows 列出 all rows in a table from an Excel workbook 删除 Table 删除-table 删除 a table from an Excel workbook. 更新 Table 更新-table 更新 properties of an existing table in an Excel workbook 创建 Table 创建-table 创建 a new table from a range in an Excel worksheet. 获取 Table 获取-table 获取 a specific table from an Excel workbook 列出 Tables 列出-tables 列出 all tables in an Excel workbook 删除 Worksh