Skip to main content

Excel GCC High

Read and write Excel workbooks for GCC High (Government Community Cloud) tenants through the Microsoft Graph API v1.0 GCC High endpoints in the US Government sovereign cloud.

📝 Beta: This connector is in beta. It follows the service's documented API but has not yet been fully tested against the live service, so some tools may behave differently than described.

What you can ask​

  • Read the used range of the Q3 Budget worksheet in a GCC High tenant
  • Append a row to the Contracts table each time a new award is recorded
  • Add a chart to a workbook and return it as an image for a status report

Set up​

Excel GCC High 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 Excel GCC High. Click Enable, and choose which tools to allow.
  2. Create an OAuth application in the Excel GCC High 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 Excel GCC High 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 (3)

Grant the scopes for the tools you plan to allow.

  • Files.Read
  • Files.ReadWrite
  • User.Read

Tools​

Excel GCC High offers 34 tools. Admins choose which ones agents can use. See Tool permission groups.

Read (14)​

View and search information without changing it.

ToolWhat it does
get_chart_imageGet a base64-encoded PNG image of a chart.
get_named_itemGet a single named item by name, including the value or formula it refers to.
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, including their values.
list_tablesList all tables in a workbook.
list_workbooksList Excel (.xlsx) workbooks in the signed-in user's own OneDrive.
list_worksheetsList worksheets in a workbook.
validate_credentialValidate Microsoft Excel credentials by calling GET /me on Microsoft Graph.

Write (7)​

Create or send 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.
create_sessionCreate an Excel workbook session and return a session_id.
refresh_sessionRefresh a workbook session to keep it alive; persistent sessions expire after ~5 minutes idle, non-persistent after ~7.

Delete or overwrite (13)​

Remove or replace existing data.

ToolWhat it does
clear_rangeClear a range's contents, formats, or both. apply_to: All (default), Contents, or Formats.
close_sessionClose an Excel workbook session created with create_session.
create_workbookCreate a new, empty Excel (.xlsx) workbook in OneDrive and return its driveItem ID (use it as item_id in other tools).
delete_chartDelete a chart from a worksheet by name or ID.
delete_tableDelete a table (the underlying cells remain).
delete_table_columnDelete a column from a table by column name or ID.
delete_table_rowDelete a table row by zero-based index.
delete_workbookDelete an Excel workbook from the signed-in user's OneDrive 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