> ## Documentation Index
> Fetch the complete documentation index at: https://docs.stackone.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Microsoft Excel

> How to set up the Microsoft Excel connector, plus the actions that are available.

![Microsoft Excel](https://stackone-logos.com/api/microsoft-excel/filled/svg)

Previewv1.2.1[See changelog](https://docs.stackone.com/connectors/microsoftexcel/changelog.md)

[102 actions](#actions) · 1 auth method

Productivity

## Getting Started

**1. Create or Select a Project**

Set up a new project or select an existing one. See [Organizations & Projects](https://docs.stackone.com/gateway/concepts/organizations-and-projects.md).

**2. Configure the Connector**

Enable the connector and create a Connector Profile in your project. See [Setup Connector Profile](https://docs.stackone.com/gateway/quickstart.md#setup-connector-profile).

> [card] [OAuth 2.0 · Connector Profile](https://docs.stackone.com/connectors/microsoftexcel/guides/connector-profile/oauth-2-0.md)
>
> Authenticate with your Microsoft Entra ID account to connect Microsoft Excel. You'll need to register an Azure applicati...

**3. Link an Account**

Link an account [from the dashboard](https://docs.stackone.com/connect/managing-connectors/linking-accounts.md#link-from-the-dashboard) (or via [StackOne Hub](https://docs.stackone.com/embed/account-linking/overview)).

See the guide for the authentication type chosen in the Connector Profile:

> [card] [OAuth 2.0 · Link Account](https://docs.stackone.com/connectors/microsoftexcel/guides/link-account/oauth-2-0.md)

**4. Use Actions**

Connect an AI platform to the linked account's actions. See [AI Platforms](https://docs.stackone.com/ai-platforms/overview.md).

Other ways to call actions are listed in [Protocols & SDKs](https://docs.stackone.com/connect/protocols-and-sdks.md).

## Actions

Scopes

Select all
|
Clear

Files.Read

Files.ReadWrite

No scopes found

102 actions

ActionDescriptionRequired scopes

List Excel Files`microsoftexcel_list_excel_files`

Search for Excel (.xlsx) files in the user's OneDrive or across all accessible drives

`Files.Read`

Get Excel File`microsoftexcel_get_excel_file`

Get metadata for a specific Excel workbook DriveItem by ID

`Files.Read`

Create Workbook Session`microsoftexcel_create_session`

Create a persistent or non-persistent workbook session

`Files.ReadWrite`

List Worksheets`microsoftexcel_list_worksheets`

Retrieve the list of worksheets in an Excel workbook

`Files.Read`

Get Worksheet`microsoftexcel_get_worksheet`

Retrieve a specific worksheet by ID or name

`Files.Read`

Create Worksheet`microsoftexcel_add_worksheet`

Create a new worksheet in an Excel workbook

`Files.ReadWrite`

Update Worksheet`microsoftexcel_update_worksheet`

Update properties of a worksheet (name, position, visibility)

`Files.ReadWrite`

Delete Worksheet`microsoftexcel_delete_worksheet`

Delete a worksheet from an Excel workbook

`Files.ReadWrite`

Get Worksheet Protection`microsoftexcel_get_worksheet_protection`

Retrieve the protection properties of a worksheet

`Files.ReadWrite`

Protect Worksheet`microsoftexcel_protect_worksheet`

Protect a worksheet with optional protection options

`Files.ReadWrite`

Unprotect Worksheet`microsoftexcel_unprotect_worksheet`

Unprotect a protected worksheet

`Files.ReadWrite`

List Tables`microsoftexcel_list_tables`

Retrieve the list of tables in an Excel workbook

`Files.Read`

Get Table`microsoftexcel_get_table`

Retrieve a specific table by ID or name

`Files.Read`

Create Table`microsoftexcel_add_table`

Create a new table in an Excel workbook

`Files.ReadWrite`

Update Table`microsoftexcel_update_table`

Update properties of a table (name, headers, totals, style)

`Files.ReadWrite`

Delete Table`microsoftexcel_delete_table`

Delete a table from an Excel workbook

`Files.ReadWrite`

Convert Table To Range`microsoftexcel_convert_table_to_range`

Convert a table to a normal range of cells

`Files.ReadWrite`

List Table Rows`microsoftexcel_list_table_rows`

Retrieve the rows of a table in an Excel workbook

`Files.Read`

Add Table Row`microsoftexcel_create_table_row`

Add a new row to a table in an Excel workbook

`Files.ReadWrite`

Delete Table Row`microsoftexcel_delete_table_row`

Delete a row from a table by its zero-based index

`Files.ReadWrite`

List Table Columns`microsoftexcel_list_table_columns`

Retrieve the columns of a table in an Excel workbook

`Files.Read`

Add Table Column`microsoftexcel_add_table_column`

Add a new column to a table in an Excel workbook

`Files.ReadWrite`

Delete Table Column`microsoftexcel_delete_table_column`

Delete a column from a table by its ID

`Files.ReadWrite`

Get Table Data Body Range`microsoftexcel_get_table_data_body_range`

Retrieve the range associated with the data body of a table

`Files.ReadWrite`

Get Table Header Row Range`microsoftexcel_get_table_header_row_range`

Retrieve the range associated with the header row of a table

`Files.ReadWrite`

Get Table Range`microsoftexcel_get_table_range`

Retrieve the range associated with the entire table

`Files.ReadWrite`

Get Table Total Row Range`microsoftexcel_get_table_total_row_range`

Retrieve the range associated with the totals row of a table

`Files.ReadWrite`

Clear Table Filters`microsoftexcel_clear_table_filters`

Clear all filters currently applied on a table

`Files.ReadWrite`

Get Table Sort`microsoftexcel_get_table_sort`

Retrieve the sort configuration of a table

`Files.ReadWrite`

Apply Table Sort`microsoftexcel_apply_table_sort`

Apply a sort operation on a table

`Files.ReadWrite`

Clear Table Sort`microsoftexcel_clear_table_sort`

Clear the current sort state of a table

`Files.ReadWrite`

Reapply Table Sort`microsoftexcel_reapply_table_sort`

Reapply the current sort parameters to a table

`Files.ReadWrite`

Apply Column Filter`microsoftexcel_apply_column_filter`

Apply filter criteria to a specific column in a table

`Files.ReadWrite`

Clear Column Filter`microsoftexcel_clear_column_filter`

Clear the filter on a specific column in a table

`Files.ReadWrite`

Get Table Sort Icon`microsoftexcel_get_table_sort_icon`

Retrieve the icon used in a table sort field

`Files.ReadWrite`

Update Table Sort Icon`microsoftexcel_update_table_sort_icon`

Update the icon used in a table sort field

`Files.ReadWrite`

Get Range`microsoftexcel_get_range`

Retrieve the properties and relationships of a cell range

`Files.ReadWrite`

Get Used Range`microsoftexcel_get_used_range`

Retrieve the used range of a worksheet

`Files.ReadWrite`

Get Cell`microsoftexcel_get_cell`

Retrieve a single cell based on row and column numbers within a range

`Files.ReadWrite`

Get Range Column`microsoftexcel_get_range_column`

Retrieve a column contained in a range

`Files.ReadWrite`

Get Columns After`microsoftexcel_get_columns_after`

Get a certain number of columns to the right of a given range

`Files.ReadWrite`

Get Columns Before`microsoftexcel_get_columns_before`

Get a certain number of columns to the left of a given range

`Files.ReadWrite`

Get Entire Column`microsoftexcel_get_entire_column`

Get the entire column of a range

`Files.ReadWrite`

Get Entire Row`microsoftexcel_get_entire_row`

Get the entire row of a range

`Files.ReadWrite`

Get Range Intersection`microsoftexcel_get_range_intersection`

Get the rectangular intersection of two ranges

`Files.ReadWrite`

Get Last Cell`microsoftexcel_get_last_cell`

Get the last cell within a range

`Files.ReadWrite`

Get Last Column`microsoftexcel_get_last_column`

Get the last column within a range

`Files.ReadWrite`

Get Last Row`microsoftexcel_get_last_row`

Get the last row within a range

`Files.ReadWrite`

Get Offset Range`microsoftexcel_get_offset_range`

Get a range offset from the specified range by a number of rows and columns

`Files.ReadWrite`

Get Resized Range`microsoftexcel_get_resized_range`

Get a range expanded or contracted from the current range

`Files.ReadWrite`

Get Range Row`microsoftexcel_get_range_row`

Get a row contained in a range

`Files.ReadWrite`

Get Rows Above`microsoftexcel_get_rows_above`

Get a certain number of rows above a given range

`Files.ReadWrite`

Get Rows Below`microsoftexcel_get_rows_below`

Get a certain number of rows below a given range

`Files.ReadWrite`

Merge Range`microsoftexcel_merge_range`

Merge the range cells into one region in the worksheet

`Files.ReadWrite`

Unmerge Range`microsoftexcel_unmerge_range`

Unmerge the range cells into separate cells

`Files.ReadWrite`

List Named Items`microsoftexcel_list_named_items`

Retrieve the named items (named ranges and constants) in an Excel workbook

`Files.ReadWrite`

Add Named Item`microsoftexcel_add_named_item`

Add a new named item (named range or constant) to an Excel workbook

`Files.ReadWrite`

Add Named Item (Formula Local)`microsoftexcel_add_named_item_formula_local`

Add a named item using a locale-specific formula to an Excel workbook

`Files.ReadWrite`

Get Named Item`microsoftexcel_get_named_item`

Retrieve the properties and relationships of a named item in an Excel workbook

`Files.ReadWrite`

Update Named Item`microsoftexcel_update_named_item`

Update the properties of a named item in an Excel workbook

`Files.ReadWrite`

Get Named Item Range`microsoftexcel_get_named_item_range`

Retrieve the range object associated with a named item

`Files.ReadWrite`

Delete Named Item`microsoftexcel_delete_named_item`

Delete a named item from an Excel workbook (beta API — may not work on v1.0)

`Files.ReadWrite`

List Charts`microsoftexcel_list_charts`

Retrieve the list of charts in a worksheet

`Files.Read`

Get Chart`microsoftexcel_get_chart`

Retrieve a specific chart by ID or name

`Files.Read`

Create Chart`microsoftexcel_add_chart`

Create a new chart in a worksheet

`Files.ReadWrite`

Update Chart`microsoftexcel_update_chart`

Update properties of a chart (name, dimensions, position)

`Files.ReadWrite`

Set Chart Position`microsoftexcel_set_chart_position`

Position a chart relative to cells on the worksheet

`Files.ReadWrite`

Set Chart Data`microsoftexcel_set_chart_data`

Reset the source data for a chart

`Files.ReadWrite`

Delete Chart`microsoftexcel_delete_chart`

Delete a chart from a worksheet

`Files.ReadWrite`

Get Chart At Index`microsoftexcel_get_chart_at`

Get a chart based on its zero-based position in the worksheet

`Files.ReadWrite`

Get Chart Image`microsoftexcel_get_chart_image`

Render a chart as a base64-encoded image

`Files.ReadWrite`

Create Chart Series`microsoftexcel_create_chart_series`

Add a new series to a chart

`Files.ReadWrite`

List Chart Series`microsoftexcel_list_chart_series`

Retrieve the list of series in a chart

`Files.Read`

Get Chart Series`microsoftexcel_get_chart_series`

Retrieve a specific series from a chart by its zero-based index

`Files.Read`

Update Chart Series`microsoftexcel_update_chart_series`

Update the name of a chart series by its zero-based index

`Files.ReadWrite`

Get Chart Axis`microsoftexcel_get_chart_axis`

Retrieve the properties of a chart axis

`Files.ReadWrite`

Update Chart Axis`microsoftexcel_update_chart_axis`

Update properties of a chart axis (min, max, units)

`Files.ReadWrite`

Get Chart Axis Title`microsoftexcel_get_chart_axis_title`

Retrieve the title of a chart axis

`Files.Read`

Update Chart Axis Title`microsoftexcel_update_chart_axis_title`

Update the title of a chart axis

`Files.ReadWrite`

Get Chart Data Labels`microsoftexcel_get_chart_data_labels`

Retrieve the data labels configuration of a chart

`Files.ReadWrite`

Update Chart Data Labels`microsoftexcel_update_chart_data_labels`

Update the data labels configuration of a chart

`Files.ReadWrite`

Clear Chart Fill`microsoftexcel_clear_chart_fill`

Clear the fill color of a chart, title, or legend element

`Files.ReadWrite`

Set Chart Fill Solid Color`microsoftexcel_set_chart_fill_solid_color`

Set the fill of a chart, title, or legend element to a solid color

`Files.ReadWrite`

Get Chart Font`microsoftexcel_get_chart_font`

Retrieve the font properties of a chart axis

`Files.ReadWrite`

Update Chart Font`microsoftexcel_update_chart_font`

Update the font properties of a chart axis

`Files.ReadWrite`

Get Chart Gridlines`microsoftexcel_get_chart_gridlines`

Retrieve the gridlines configuration of a chart axis

`Files.ReadWrite`

Update Chart Gridlines`microsoftexcel_update_chart_gridlines`

Update the visibility of chart axis gridlines

`Files.ReadWrite`

Get Chart Legend`microsoftexcel_get_chart_legend`

Retrieve the legend properties of a chart

`Files.ReadWrite`

Update Chart Legend`microsoftexcel_update_chart_legend`

Update the legend properties of a chart

`Files.ReadWrite`

Get Chart Line Format`microsoftexcel_get_chart_line_format`

Retrieve the line format properties of a chart axis or gridlines

`Files.ReadWrite`

Update Chart Line Format`microsoftexcel_update_chart_line_format`

Update the line color of a chart axis or gridlines

`Files.ReadWrite`

Clear Chart Line Format`microsoftexcel_clear_chart_line_format`

Clear the line format of a chart axis or gridlines

`Files.ReadWrite`

List Chart Points`microsoftexcel_list_chart_points`

Retrieve the list of data points in a chart series

`Files.ReadWrite`

Get Chart Point`microsoftexcel_get_chart_point`

Retrieve a specific data point in a chart series by ID

`Files.ReadWrite`

Get Chart Point At Index`microsoftexcel_get_chart_point_at`

Retrieve a data point by its zero-based index within a chart series

`Files.ReadWrite`

Get Chart Title`microsoftexcel_get_chart_title`

Retrieve the title properties of a chart

`Files.ReadWrite`

Update Chart Title`microsoftexcel_update_chart_title`

Update the title properties of a chart

`Files.ReadWrite`

List Comments`microsoftexcel_list_comments`

Retrieve the list of comments in an Excel workbook

`Files.ReadWrite`

Get Comment`microsoftexcel_get_comment`

Retrieve a specific comment in an Excel workbook by ID

`Files.ReadWrite`

List Comment Replies`microsoftexcel_list_comment_replies`

Retrieve the list of replies for a workbook comment

`Files.ReadWrite`

Create Comment Reply`microsoftexcel_create_comment_reply`

Create a new reply to a workbook comment

`Files.ReadWrite`

Get Comment Reply`microsoftexcel_get_comment_reply`

Retrieve a specific reply to a workbook comment by ID

`Files.ReadWrite`


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.