Microsoft Excel

Appends one or more new data rows to the bottom of a named Excel table, keeping the table's structure and formulas intact.

Writes a single new row of data to a specified worksheet at the next available position.

Returns the column headers of a named Excel table so the agent knows the schema before reading or writing data.

Writes multiple rows to a worksheet in a single call, ideal for batch imports that would otherwise require many round-trips.

Fetches all rows from a named Excel table, returning structured data the agent can filter, transform, or forward downstream.

Inserts a new record into a specific named table within a worksheet, preserving table formatting and auto-extending the table range.

Searches a named table for a row where a specified column equals a target value and returns the full row data — Excel's VLOOKUP, executed by the agent.

Erases the content of a specified cell range (e.g. B2:D50) while leaving the cells, formatting, and formulas in surrounding areas untouched.

Creates a fresh worksheet tab inside an existing workbook, ready to receive data without overwriting any current sheets.

Empties all data in a specific column (identified by index position) without touching the rest of the worksheet.

Lists every workbook available to the connected account in OneDrive, returning names, IDs, and metadata so the agent can locate the right file before acting.

Removes all data from a specific row identified by its row ID, leaving the row structure intact for re-use.

Returns the names and IDs of every worksheet tab in a workbook, letting the agent navigate complex multi-tab files programmatically.

Provisions a brand-new Excel workbook in the connected OneDrive, ready to receive worksheets, tables, and data.

Reads all cell values from a specified worksheet, returning the full data grid the agent can parse, analyse, or forward to other systems.

Adds a new named worksheet tab to an existing workbook, giving the agent a clean surface to write structured data.

Permanently removes a worksheet tab from a workbook, useful for cleaning up temporary or staging sheets after data has been processed.

Changes the display name of an existing worksheet tab to a new value, keeping all data, formulas, and cell references intact.

Overwrites specific cells in an existing row identified by its row ID, updating only the fields that have changed without touching the rest of the row.

Searches a worksheet for rows matching specified criteria and returns all matching records, enabling the agent to locate data without knowing exact positions.

Searches a workbook for worksheet tabs matching a name pattern, returning matching sheet names and IDs.

Returns the values of all cells within a specific A1-notation range (e.g. A1:F20), letting the agent work with named blocks of data precisely.

Fetches the full data of a single row by its unique row identifier, allowing the agent to retrieve one record without scanning the whole sheet.

Retrieves the metadata and content of a specific worksheet using its internal identifier rather than its display name.

Fires whenever a new row is added to a monitored worksheet, letting the agent react to fresh data the moment it lands.

Fires when a new row is inserted into a specifically named Excel table, scoped precisely so only the target table triggers downstream logic.

Fires when a new worksheet tab is added to a monitored workbook, enabling the agent to act on structural changes rather than just data changes.

Fires when any cell in an existing worksheet row changes value, so the agent can react to edits rather than only new entries.

Fires when any change is saved to a monitored workbook, enabling the agent to react to any modification regardless of which sheet or cell was edited.

Fires specifically when a row is added to a named Excel table object, giving finer scope than worksheet-level row monitoring.

Fires when a specific cell or range changes value within a worksheet, enabling surgical reactions to key data points.

Fires when any value within a defined named range (such as 'SalesForecast' or 'Q3Targets') changes, enabling the agent to monitor semantically meaningful data blocks.