add-excel

1**📋 Shared Instructions: [shared-instructions.md](../../shared/shared-instructions.md)** - Cross-cutting concerns.
2 
3# Add Excel Online
4 
5## Workflow
6 
71. Check Memory Bank → 2. Gather → 3. Add Connector → 4. Configure → 5. Build → 6. Update Memory Bank
8 
9---
10 
11### Step 1: Check Memory Bank
12 
13Check for `memory-bank.md` per [shared-instructions.md](../../shared/shared-instructions.md).
14 
15### Step 2: Gather
16 
17Ask the user:
18 
191. Where is the workbook? (OneDrive or SharePoint)
202. Workbook file name
213. Which table(s) in the workbook to access
22 
23### Step 3: Add Connector
24 
25**First, find the connection ID** (see [connector-reference.md](../../shared/connector-reference.md)):
26 
27Run 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.
28 
29Excel Online is a tabular datasource -- requires `-c` (connection ID), `-d` (drive), and `--table` (table name in workbook):
30 
31```bash
32# OneDrive workbook
33pa app add data-source --connector excelonlinebusiness -c <connection-id> -d 'me' --table 'Table1'
34 
35# SharePoint workbook -- dataset is the document library path
36…