Microsoft Excel
Read and write Excel workbooks in OneDrive and SharePoint through the Microsoft Graph API.
What you can ask
- Read the
Pipelineworksheet from a shared workbook and total deal value by stage. - Append this week's signups to the
Growth Metricsworkbook in SharePoint. - Update the forecast tab with the latest actuals and recalculate variance.
Set up
Microsoft Excel needs an OAuth application from your organization before anyone can connect. An organization admin completes these steps once.
- Go to Organization > Connectors and find Microsoft Excel. Click Enable, and choose which tools to allow.
- Create an OAuth application in the Microsoft Excel developer portal.
- Add the Redirect URI shown in the connector settings to the application.
- Copy the application's Client ID and Client Secret into the connector, then save it.
- Each member connects their own account the first time they use it.
⚠️ Warning: Do not enter your Devs.ai or Microsoft Excel login email or password in the OAuth application fields.
To use one account for the whole organization, turn on Share one connection with everyone. Every member's agents then act as that account, with exactly the access it has.
OAuth scopes used by these tools (5)
Grant the scopes for the tools you plan to allow.
Files.Read.AllFiles.ReadWrite.AllSites.Read.AllSites.ReadWrite.AllUser.Read
Tools
Microsoft Excel offers 31 tools. Admins choose which ones agents can use. See Tool permission groups.
Read (16)
View and search information without changing it.
| Tool | What it does |
|---|---|
close_session | Close an Excel workbook session created with create_session. |
create_session | Create an Excel workbook session and return a session_id. |
get_chart_image | Get a base64-encoded PNG image of a chart. |
get_named_item | Get a single named item by name. |
get_range | Get a cell range's values, text, and formulas by address (e.g. 'A1:B2'). |
get_table | Get a table by name or ID. |
get_used_range | Get the used range of a worksheet (the smallest range covering all cells with data). |
get_worksheet | Get a worksheet by name or ID. |
list_charts | List charts in a worksheet. |
list_named_items | List named items (named ranges and constants) defined in a workbook. |
list_table_columns | List columns of a table, including their values. |
list_table_rows | List data rows of a table. |
list_tables | List all tables in a workbook. |
list_workbooks | List Excel (.xlsx) workbooks in the user's OneDrive/SharePoint. |
list_worksheets | List worksheets in a workbook. |
validate_credential | Validate Microsoft Excel credentials by calling GET /me on Microsoft Graph. |
Delete or overwrite (15)
Remove or replace existing data.
| Tool | What it does |
|---|---|
add_chart | Add a chart to a worksheet from a data range. chart_type e.g. 'ColumnClustered', 'Line', 'Pie'. source_data e.g. 'A1:C4'. series_by: Auto, Columns, or Rows. |
add_table | Create a table over a range, e.g. address 'Sheet1!A1:C5' with has_headers=true. |
add_table_column | Add a column to a table. values is a 2-D array including the header, e.g. [['Status'], ['Open'], ['Closed']]. |
add_table_row | Add one or more rows to a table. values is a 2-D array, e.g. [['Jan', 49, 37]]. |
add_worksheet | Add a new worksheet to a workbook. |
clear_range | Clear a range's contents, formats, or both. apply_to: All (default), Contents, or Formats. |
create_workbook | Create a new, empty Excel (.xlsx) workbook in OneDrive and return its driveItem ID (use it as item_id in other tools). |
delete_table | Delete a table (the underlying cells remain). |
delete_table_row | Delete a table row by zero-based index. |
delete_workbook | Delete an Excel workbook from OneDrive/SharePoint by its driveItem ID. |
delete_worksheet | Delete a worksheet by name or ID. |
sort_table | Sort a table by one or more columns. fields is a list of {key (zero-based column index), ascending}. |
update_range | Write values, formulas, or number formats to a bounded range (e.g. 'A1:B2'). |
update_table | Update a table's name, header/totals visibility, or style. |
update_worksheet | Update a worksheet's name, position, or visibility. |