Excel GCC High

Connect your AI agents to Excel GCC High.

This Connector is in Beta

Merge has validated Excel GCC High against the provider’s documented API and not yet verified it against the live one, so its behavior can differ from the documentation. It carries the same tool surface it will have at general availability. Connectors overview covers the tier and how to turn Beta Connectors off.

Authentication: OAuth or access token. See Magic Link for the runtime auth flow, or Application credentials to bring your own OAuth app.

Sample use cases

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

Available Tools

list_charts

List charts in a worksheet. Use list_worksheets to find worksheets. Use cursor from page_info for the next page.

add_chart

Add a chart to a worksheet from a data range. chart_type e.g. ‘ColumnClustered’, ‘Line’, ‘Pie’. source_data e.g…

get_chart_image

Get a base64-encoded PNG image of a chart. Use list_charts to find chart names/IDs. width/height of 0 use the…

delete_chart

Delete a chart from a worksheet by name or ID. Use list_charts to find chart names/IDs.

list_named_items

List named items (named ranges and constants) defined in a workbook. Use list_workbooks to find item_id. Errors if a…

get_named_item

Get a single named item by name, including the value or formula it refers to. Use list_named_items to find valid…

get_range

Get a cell range’s values, text, and formulas by address (e.g. ‘A1:B2’). Use list_worksheets to find worksheets…

get_used_range

Get the used range of a worksheet (the smallest range covering all cells with data). Set values_only=true to ignore…

update_range

Write values, formulas, or number formats to a bounded range (e.g. ‘A1:B2’). Provide 2-D arrays matching the range…

clear_range

Clear a range’s contents, formats, or both. apply_to: All (default), Contents, or Formats. Use for resetting cells…

list_tables

List all tables in a workbook. Use list_workbooks to find item_id. Use cursor from page_info for the next page.

get_table

Get a table by name or ID. Use list_tables to find valid tables.

add_table

Create a table over a range, e.g. address ‘Sheet1!A1:C5’ with has_headers=true. Use list_worksheets to find sheet names.

update_table

Update a table’s name, header/totals visibility, or style. Use list_tables to find valid tables.

delete_table

Delete a table (the underlying cells remain). Use list_tables to find valid tables.

list_table_rows

List data rows of a table, including their values. Use list_tables to find tables. Use cursor from page_info for the…

add_table_row

Add one or more rows to a table. values is a 2-D array, e.g. [[‘Jan’, 49, 37]]. Omit index to append. Use…

delete_table_row

Delete a table row by zero-based index. Use list_table_rows to find row indexes.

list_table_columns

List columns of a table, including their values. Use list_tables to find tables. Use cursor from page_info for the…

add_table_column

Add a column to a table. values is a 2-D array including the header, e.g. [[‘Status’], [‘Open’], [‘Closed’]]. Omit…

delete_table_column

Delete a column from a table by column name or ID. Use list_table_columns to find columns. Deletes the column’s data.

sort_table

Sort a table by one or more columns. Use list_table_columns to find column indexes.

list_workbooks

List Excel (.xlsx) workbooks in the signed-in user’s own OneDrive. Optionally filter by name with query. Returns…

create_workbook

Create a new, empty Excel (.xlsx) workbook in OneDrive and return its driveItem ID (use it as item_id in other…

delete_workbook

Delete an Excel workbook from the signed-in user’s OneDrive by its driveItem ID. This permanently removes the file…

create_session

Create an Excel workbook session and return a session_id. Pass that session_id on subsequent tools so…

close_session

Close an Excel workbook session created with create_session. Provide the session_id to close.

refresh_session

Refresh a workbook session to keep it alive; persistent sessions expire after ~5 minutes idle, non-persistent after…

list_worksheets

List worksheets in a workbook. Use list_workbooks to find item_id. Use cursor from page_info for the next page.

get_worksheet

Get a worksheet by name or ID. Use list_worksheets to find valid worksheets.

add_worksheet

Add a new worksheet to a workbook. Optionally provide a name. Use list_workbooks to find item_id.

update_worksheet

Update a worksheet’s name, position, or visibility. Use list_worksheets to find valid worksheets.

delete_worksheet

Delete a worksheet by name or ID. This permanently removes the sheet and its data. Use list_worksheets to find valid…