Microsoft Excel

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 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.

Available Tools

list_charts

List charts in a worksheet

add_chart

Add a chart to a worksheet from a data range

get_chart_image

Get a base64-encoded PNG image of a chart

list_named_items

List named items (named ranges and constants) defined in a workbook

get_named_item

Get a single named item by name

get_range

Get a cell range’s values, text, and formulas by address (e.g

get_used_range

Get the used range of a worksheet (the smallest range covering all cells with data)

update_range

Write values, formulas, or number formats to a bounded range (e.g

clear_range

Clear a range’s contents, formats, or both

list_tables

List all tables in a workbook

get_table

Get a table by name or ID

add_table

Create a table over a range, e.g

update_table

Update a table’s name, header/totals visibility, or style

delete_table

Delete a table (the underlying cells remain)

list_table_rows

List data rows of a table

add_table_row

Add one or more rows to a table

delete_table_row

Delete a table row by zero-based index

list_table_columns

List columns of a table, including their values

add_table_column

Add a column to a table

sort_table

Sort a table by one or more columns

list_workbooks

List Excel (.xlsx) workbooks in the user’s OneDrive/SharePoint

create_workbook

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

delete_workbook

Delete an Excel workbook from OneDrive/SharePoint by its driveItem ID

create_session

Create an Excel workbook session and return a session_id

close_session

Close an Excel workbook session created with create_session

list_worksheets

List worksheets in a workbook

get_worksheet

Get a worksheet by name or ID

add_worksheet

Add a new worksheet to a workbook

update_worksheet

Update a worksheet’s name, position, or visibility

delete_worksheet

Delete a worksheet by name or ID