Excel GCC High
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 Budgetworksheet in a GCC High tenant - Append a row to the
Contractstable 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 in a worksheet. Use list_worksheets to find worksheets. Use cursor from page_info for the next page.
Add a chart to a worksheet from a data range. chart_type e.g. ‘ColumnClustered’, ‘Line’, ‘Pie’. source_data e.g…
Get a base64-encoded PNG image of a chart. Use list_charts to find chart names/IDs. width/height of 0 use the…
Delete a chart from a worksheet by name or ID. Use list_charts to find chart names/IDs.
List named items (named ranges and constants) defined in a workbook. Use list_workbooks to find item_id. Errors if a…
Get a single named item by name, including the value or formula it refers to. Use list_named_items to find valid…
Get a cell range’s values, text, and formulas by address (e.g. ‘A1:B2’). Use list_worksheets to find worksheets…
Get the used range of a worksheet (the smallest range covering all cells with data). Set values_only=true to ignore…
Write values, formulas, or number formats to a bounded range (e.g. ‘A1:B2’). Provide 2-D arrays matching the range…
Clear a range’s contents, formats, or both. apply_to: All (default), Contents, or Formats. Use for resetting cells…
List all tables in a workbook. Use list_workbooks to find item_id. Use cursor from page_info for the next page.
Get a table by name or ID. Use list_tables to find valid tables.
Create a table over a range, e.g. address ‘Sheet1!A1:C5’ with has_headers=true. Use list_worksheets to find sheet names.
Update a table’s name, header/totals visibility, or style. Use list_tables to find valid tables.
Delete a table (the underlying cells remain). Use list_tables to find valid tables.
List data rows of a table, including their values. Use list_tables to find tables. Use cursor from page_info for the…
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 a table row by zero-based index. Use list_table_rows to find row indexes.
List columns of a table, including their values. Use list_tables to find tables. Use cursor from page_info for the…
Add a column to a table. values is a 2-D array including the header, e.g. [[‘Status’], [‘Open’], [‘Closed’]]. Omit…
Delete a column from a table by column name or ID. Use list_table_columns to find columns. Deletes the column’s data.
Sort a table by one or more columns. Use list_table_columns to find column indexes.
List Excel (.xlsx) workbooks in the signed-in user’s own OneDrive. Optionally filter by name with query. Returns…
Create a new, empty Excel (.xlsx) workbook in OneDrive and return its driveItem ID (use it as item_id in other…
Delete an Excel workbook from the signed-in user’s OneDrive by its driveItem ID. This permanently removes the file…
Create an Excel workbook session and return a session_id. Pass that session_id on subsequent tools so…
Close an Excel workbook session created with create_session. Provide the session_id to close.
Refresh a workbook session to keep it alive; persistent sessions expire after ~5 minutes idle, non-persistent after…
List worksheets in a workbook. Use list_workbooks to find item_id. Use cursor from page_info for the next page.
Get a worksheet by name or ID. Use list_worksheets to find valid worksheets.
Add a new worksheet to a workbook. Optionally provide a name. Use list_workbooks to find item_id.
Update a worksheet’s name, position, or visibility. Use list_worksheets to find valid worksheets.
Delete a worksheet by name or ID. This permanently removes the sheet and its data. Use list_worksheets to find valid…