Microsoft Excel (Microsoft Graph workbook API) vs Teable

Microsoft Excel (Microsoft Graph workbook API)

Ranges, tables, charts and 366 worksheet function endpoints are reachable over REST with a public OpenAPI, and a non-persistent session lets an agent test changes without saving them. The reference pages list delegated permissions only, with Files.ReadWrite as the least privileged scope, and writes take no idempotency key.

Teable

Personal access tokens and OAuth tokens carry per-action scopes, and tokens can be limited to chosen spaces and projects. The public OpenAPI file covers 841 operations. Error responses beyond 200 and 201 are missing from that file, no idempotency keys were found, and the cloud allows 10 requests a second on every plan.

Microsoft Excel (Microsoft Graph workbook API)

1. Create a session with POST /workbook/createSession and send workbook-session-id on every call. Persistent sessions expire after about 5 minutes idle
2. Set persistChanges to false when you only need a calculation or a chart image, so nothing is saved to the file
3. Send one request at a time per workbook and wait for each response. Microsoft warns that parallel writes cause throttling, timeouts and merge conflicts
4. Add rows in one call with a two-dimensional values array, and check the table before repeating a row add that returned 504
5. Read bounded addresses such as A1:D500. A whole-column range such as C:C returns null for values, and writes to it are refused

Teable

1. Send Authorization: Bearer <token> to https://app.teable.ai/api. A 403 with code restricted_resource usually means a missing scope or a project outside the token's list
2. Page records with take of 100 at most. Personal keys created on Teable Cloud since 10 September 2026 are capped at 100 a request
3. Ask for totals from /api/table/{tableId}/aggregation/row-count. Record lists stopped returning them by default on 2 September 2026
4. Keep to 10 requests a second, back off on 429, and check before retrying a failed write because no idempotency key exists
5. Pass fieldKeyType=id so renamed fields don't break writes, and leave typecast off unless values need converting