$ loading_
为 Power Apps 代码应用添加 Excel Online 连接器，便于读写 OneDrive 或 SharePoint 中的表格数据。
复制安装指令，让 AI 自动完成配置 · 推荐新手
请帮我安装 askskill 上的 "add-excel" 技能： 1. 下载 https://raw.githubusercontent.com/microsoft/power-platform-skills/main/plugins/code-apps/skills/add-excel/SKILL.md 2. 保存为 ~/.claude/skills/add-excel/SKILL.md 3. 装好后重载技能，告诉我可以用了
为我的 Power Apps 代码应用添加 Excel Online (Business) 连接器，并连接存储在 OneDrive 中的销售数据工作簿。
应用已配置 Excel 连接器，可访问 OneDrive 中指定工作簿的数据表。
在 Power Apps 代码应用中添加 Excel Online (Business) 连接器，用于读取 SharePoint 上库存工作簿里的产品表数据。
应用获得读取 SharePoint Excel 工作簿表格记录的能力，可用于展示或分析数据。
帮我在 Power Apps 代码应用中添加 Excel Online (Business) 连接器，以便将用户提交的数据写入 SharePoint 中的 Excel 工作簿。
应用已接入 Excel 写入能力，可将新业务记录保存到指定云端工作簿。
📋 Shared Instructions: shared-instructions.md - Cross-cutting concerns.
Check for memory-bank.md per shared-instructions.md.
Ask the user:
First, find the connection ID (see connector-reference.md):
Run the /list-connections skill. Find the Excel Online (Business) connection in the output. If none exists, direct the user to create one using the environment-specific Connections URL — construct it from the active environment ID in context (from power.config.json or a prior step): https://make.powerapps.com/environments/<environment-id>/connections → + New connection → search for the connector → Create.
Excel Online is a tabular datasource -- requires -c (connection ID), -d (drive), and -t (table name in workbook):
# OneDrive workbook
npx power-apps add-data-source -a excelonlinebusiness -c <connection-id> -d 'me' -t 'Table1'
# SharePoint workbook -- dataset is the document library path
npx power-apps add-data-source -a excelonlinebusiness -c <connection-id> -d 'sites/your-site' -t 'Table1'
Run for each table the user needs.
AddRowIntoTable -- adds a row to an Excel table:
// OneDrive workbook
await ExcelOnlineBusinessService.AddRowIntoTable({
source: "me",
drive: "me",
file: "MyWorkbook.xlsx",
table: "Table1",
body: { column1: "value1", column2: "value2" } // Flat object, NO "items" wrapper
});
// SharePoint workbook
await ExcelOnlineBusinessService.AddRowIntoTable({
source: "sites/your-site",
drive: "drive-id",
file: "SharedWorkbook.xlsx",
table: "Table1",
body: { column1: "value1", column2: "value2" }
});
Key points:
source: "me" and drive: "me" for OneDrive personal filesbody is a flat key-value object matching column headers -- do NOT wrap in { items: ... }Use Grep to find specific methods in src/generated/services/ExcelOnlineBusinessService.ts (generated files can be very large -- see connector-reference.md).
npm run build
Fix TypeScript errors before proceeding. Do NOT deploy yet.
Update memory-bank.md with: connector added, workbook/table configured, build status.
为 Power Apps 代码应用接入 Azure DevOps 连接器，便于查询工单、提报缺陷与管理流水线。
为 Power Apps 代码应用接入 Office 365 Outlook，实现邮件、日历与事件管理。