Skip to main content

Microsoft Excel

Read and write Excel workbooks in OneDrive and SharePoint through the Microsoft Graph API.

What you can ask​

  • Read the Pipeline worksheet from a shared workbook and total deal value by stage.
  • Append this week's signups to the Growth Metrics workbook 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.

  1. Go to Organization > Connectors and find Microsoft Excel. Click Enable, and choose which tools to allow.
  2. Create an OAuth application in the Microsoft Excel developer portal.
  3. Add the Redirect URI shown in the connector settings to the application.
  4. Copy the application's Client ID and Client Secret into the connector, then save it.
  5. 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.All
  • Files.ReadWrite.All
  • Sites.Read.All
  • Sites.ReadWrite.All
  • User.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.

ToolWhat it does
close_sessionClose an Excel workbook session created with create_session.
create_sessionCreate an Excel workbook session and return a session_id.
get_chart_imageGet a base64-encoded PNG image of a chart.
get_named_itemGet a single named item by name.
get_rangeGet a cell range's values, text, and formulas by address (e.g. 'A1:B2').
get_tableGet a table by name or ID.
get_used_rangeGet the used range of a worksheet (the smallest range covering all cells with data).
get_worksheetGet a worksheet by name or ID.
list_chartsList charts in a worksheet.
list_named_itemsList named items (named ranges and constants) defined in a workbook.
list_table_columnsList columns of a table, including their values.
list_table_rowsList data rows of a table.
list_tablesList all tables in a workbook.
list_workbooksList Excel (.xlsx) workbooks in the user's OneDrive/SharePoint.
list_worksheetsList worksheets in a workbook.
validate_credentialValidate Microsoft Excel credentials by calling GET /me on Microsoft Graph.

Delete or overwrite (15)​

Remove or replace existing data.

ToolWhat it does
add_chartAdd 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_tableCreate a table over a range, e.g. address 'Sheet1!A1:C5' with has_headers=true.
add_table_columnAdd a column to a table. values is a 2-D array including the header, e.g. [['Status'], ['Open'], ['Closed']].
add_table_rowAdd one or more rows to a table. values is a 2-D array, e.g. [['Jan', 49, 37]].
add_worksheetAdd a new worksheet to a workbook.
clear_rangeClear a range's contents, formats, or both. apply_to: All (default), Contents, or Formats.
create_workbookCreate a new, empty Excel (.xlsx) workbook in OneDrive and return its driveItem ID (use it as item_id in other tools).
delete_tableDelete a table (the underlying cells remain).
delete_table_rowDelete a table row by zero-based index.
delete_workbookDelete an Excel workbook from OneDrive/SharePoint by its driveItem ID.
delete_worksheetDelete a worksheet by name or ID.
sort_tableSort a table by one or more columns. fields is a list of {key (zero-based column index), ascending}.
update_rangeWrite values, formulas, or number formats to a bounded range (e.g. 'A1:B2').
update_tableUpdate a table's name, header/totals visibility, or style.
update_worksheetUpdate a worksheet's name, position, or visibility.
⌘J