> This page is for Agent Handler. > For clean Markdown of any page, append .md to the page URL. > For a complete documentation index, see https://docs.merge.dev/llms.txt. > For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.merge.dev/_mcp/server. # Excel GCC High **Authentication:** OAuth or access token. See [Magic Link](/merge-agent-handler/features/magic-link) for the runtime auth flow, or [Application credentials](/merge-agent-handler/admin-setup/add-oauth-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...