Microsoft Excel

Let your agents read and write Excel workbooks stored in OneDrive: list worksheets, read used ranges, manage tables and named items, add worksheets and table rows.

Connection

Authentication: OAuth 2.0 — you authorize Atako via Microsoft Excel’s consent screen; no key to copy.
Scopes requested:
- offline_access
- User.Read
- Files.Read
- Files.ReadWrite

Nothing to paste: click Connect and sign in with your Microsoft 365 work or school account. The workbook is identified by its OneDrive drive item id — obtain it via the OneDrive connector (list_root_children / list_children). Prerequisite on the Atako side — same Microsoft Entra app as Outlook, Teams and OneDrive: an administrator sets INTEGRATION_OAUTH_EXCEL_CLIENT_ID / _CLIENT_SECRET to the same values as INTEGRATION_OAUTH_OUTLOOK_CLIENT_ID / _CLIENT_SECRET, and adds the delegated permission Files.ReadWrite in Entra → App registrations → Atako → API permissions → Microsoft Graph → Delegated.See Microsoft Excel’s documentation.

Read actions (7)

Action	Description
`get_table`	Get metadata for a single table (id, name, showHeaders, showTotals, style, worksheet). The table can be a name or id from list_tables.
`get_used_range`	Get the used range of a worksheet (the smallest rectangle that contains all cells with data). Returns address, values (2D array of rows, each row = array of cell values), formulas, numberFormat, rowCount, columnCount. The worksheet can be a name or id from list_worksheets.
`list_charts`	List charts in a worksheet. Returns id, name, height, width, top, left for each chart. Does not return chart images (binary, excluded).
`list_named_items`	List named items (defined names / named ranges) in the workbook. Returns name, type, value (formula or range address), visible for each item.
`list_table_rows`	List rows of a table. Each row contains index and values (2D array: each row = array of cell values). Optional: top (page size, default 200), skip (offset).
`list_tables`	List all tables in the workbook. Returns id, name, showHeaders, showTotals, style for each table.
`list_worksheets`	List all worksheets in the workbook. Returns id, name, position and visibility for each sheet. The item_id is the OneDrive drive item id of the workbook.

Write actions (3)

Action	Description
`add_table`	Create a table in the workbook. address is the cell range in A1 notation (e.g. “Sheet1!A1:D5”). hasHeaders indicates whether the first row contains column names (boolean). Returns the created table (id, name, showHeaders, showTotals, style).
`add_table_rows`	Add rows to a table. values is a 2D array: each inner array is one row, each element is a cell value (string or number). The number of values per row must match the table column count. index (integer, 0-based) specifies where to insert; omit or null to append at the end.
`add_worksheet`	Add a new worksheet to the workbook. The name parameter is the sheet name (string, 1–31 characters, must not contain \ / * [ ] : ?). Returns the created worksheet (id, name, position, visibility).

Permissions

Every action above must be explicitly granted to an agent before it can be used. See Permissions for the grant model and Security for how credentials are protected.

Using integrations

Communication

Scheduling

Project management

Docs & design

Files & storage

CRM & sales

Customer support

HR & recruiting

Commerce & billing

Developer tools

Observability & analytics

AI & media

Microsoft Excel

Connection

Read actions (7)

Write actions (3)

Permissions

​Connection

​Read actions (7)

​Write actions (3)

​Permissions

Connection

Read actions (7)

Write actions (3)

Permissions