Skip to main content
Microsoft Excel
Microsoft Excel
102 actions · 1 auth method
PreviewDocuments

​
Authentication

OAuth 2.0

Authenticate with your Microsoft Entra ID account to connect Microsoft Excel. You’ll need to register an Azure applicati…Guides: Connector Profile, Link Account
Actions
|
102 actions
Action
Description
Required scopes
List Excel Files
Search for Excel (.xlsx) files in the user’s OneDrive or across all accessible drives
Get Excel File
Get metadata for a specific Excel workbook DriveItem by ID
Create Workbook Session
Create a persistent or non-persistent workbook session
List Worksheets
Retrieve the list of worksheets in an Excel workbook
Get Worksheet
Retrieve a specific worksheet by ID or name
Create Worksheet
Create a new worksheet in an Excel workbook
Update Worksheet
Update properties of a worksheet (name, position, visibility)
Delete Worksheet
Delete a worksheet from an Excel workbook
Get Worksheet Protection
Retrieve the protection properties of a worksheet
Protect Worksheet
Protect a worksheet with optional protection options
Unprotect Worksheet
Unprotect a protected worksheet
List Tables
Retrieve the list of tables in an Excel workbook
Get Table
Retrieve a specific table by ID or name
Create Table
Create a new table in an Excel workbook
Update Table
Update properties of a table (name, headers, totals, style)
Delete Table
Delete a table from an Excel workbook
Convert Table To Range
Convert a table to a normal range of cells
List Table Rows
Retrieve the rows of a table in an Excel workbook
Add Table Row
Add a new row to a table in an Excel workbook
Delete Table Row
Delete a row from a table by its zero-based index
List Table Columns
Retrieve the columns of a table in an Excel workbook
Add Table Column
Add a new column to a table in an Excel workbook
Delete Table Column
Delete a column from a table by its ID
Get Table Data Body Range
Retrieve the range associated with the data body of a table
Get Table Header Row Range
Retrieve the range associated with the header row of a table
Get Table Range
Retrieve the range associated with the entire table
Get Table Total Row Range
Retrieve the range associated with the totals row of a table
Clear Table Filters
Clear all filters currently applied on a table
Get Table Sort
Retrieve the sort configuration of a table
Apply Table Sort
Apply a sort operation on a table
Clear Table Sort
Clear the current sort state of a table
Reapply Table Sort
Reapply the current sort parameters to a table
Apply Column Filter
Apply filter criteria to a specific column in a table
Clear Column Filter
Clear the filter on a specific column in a table
Get Table Sort Icon
Retrieve the icon used in a table sort field
Update Table Sort Icon
Update the icon used in a table sort field
Get Range
Retrieve the properties and relationships of a cell range
Get Used Range
Retrieve the used range of a worksheet
Get Cell
Retrieve a single cell based on row and column numbers within a range
Get Range Column
Retrieve a column contained in a range
Get Columns After
Get a certain number of columns to the right of a given range
Get Columns Before
Get a certain number of columns to the left of a given range
Get Entire Column
Get the entire column of a range
Get Entire Row
Get the entire row of a range
Get Range Intersection
Get the rectangular intersection of two ranges
Get Last Cell
Get the last cell within a range
Get Last Column
Get the last column within a range
Get Last Row
Get the last row within a range
Get Offset Range
Get a range offset from the specified range by a number of rows and columns
Get Resized Range
Get a range expanded or contracted from the current range
Get Range Row
Get a row contained in a range
Get Rows Above
Get a certain number of rows above a given range
Get Rows Below
Get a certain number of rows below a given range
Merge Range
Merge the range cells into one region in the worksheet
Unmerge Range
Unmerge the range cells into separate cells
List Named Items
Retrieve the named items (named ranges and constants) in an Excel workbook
Add Named Item
Add a new named item (named range or constant) to an Excel workbook
Add Named Item (Formula Local)
Add a named item using a locale-specific formula to an Excel workbook
Get Named Item
Retrieve the properties and relationships of a named item in an Excel workbook
Update Named Item
Update the properties of a named item in an Excel workbook
Get Named Item Range
Retrieve the range object associated with a named item
Delete Named Item
Delete a named item from an Excel workbook (beta API — may not work on v1.0)
List Charts
Retrieve the list of charts in a worksheet
Get Chart
Retrieve a specific chart by ID or name
Create Chart
Create a new chart in a worksheet
Update Chart
Update properties of a chart (name, dimensions, position)
Set Chart Position
Position a chart relative to cells on the worksheet
Set Chart Data
Reset the source data for a chart
Delete Chart
Delete a chart from a worksheet
Get Chart At Index
Get a chart based on its zero-based position in the worksheet
Get Chart Image
Render a chart as a base64-encoded image
Create Chart Series
Add a new series to a chart
List Chart Series
Retrieve the list of series in a chart
Get Chart Series
Retrieve a specific series from a chart by its zero-based index
Update Chart Series
Update the name of a chart series by its zero-based index
Get Chart Axis
Retrieve the properties of a chart axis
Update Chart Axis
Update properties of a chart axis (min, max, units)
Get Chart Axis Title
Retrieve the title of a chart axis
Update Chart Axis Title
Update the title of a chart axis
Get Chart Data Labels
Retrieve the data labels configuration of a chart
Update Chart Data Labels
Update the data labels configuration of a chart
Clear Chart Fill
Clear the fill color of a chart, title, or legend element
Set Chart Fill Solid Color
Set the fill of a chart, title, or legend element to a solid color
Get Chart Font
Retrieve the font properties of a chart axis
Update Chart Font
Update the font properties of a chart axis
Get Chart Gridlines
Retrieve the gridlines configuration of a chart axis
Update Chart Gridlines
Update the visibility of chart axis gridlines
Get Chart Legend
Retrieve the legend properties of a chart
Update Chart Legend
Update the legend properties of a chart
Get Chart Line Format
Retrieve the line format properties of a chart axis or gridlines
Update Chart Line Format
Update the line color of a chart axis or gridlines
Clear Chart Line Format
Clear the line format of a chart axis or gridlines
List Chart Points
Retrieve the list of data points in a chart series
Get Chart Point
Retrieve a specific data point in a chart series by ID
Get Chart Point At Index
Retrieve a data point by its zero-based index within a chart series
Get Chart Title
Retrieve the title properties of a chart
Update Chart Title
Update the title properties of a chart
List Comments
Retrieve the list of comments in an Excel workbook
Get Comment
Retrieve a specific comment in an Excel workbook by ID
List Comment Replies
Retrieve the list of replies for a workbook comment
Create Comment Reply
Create a new reply to a workbook comment
Get Comment Reply
Retrieve a specific reply to a workbook comment by ID

​
Getting Started

1

Create or Select a Project

Set up a new project or select an existing one. See the Projects Guide.
2

Configure the Connector

Enable the connector and set up a connector profile in your project. See Managing Connectors.
https://stackone-logos.com/api/microsoft-excel/filled/png

Connector Profile

Microsoft Excel - OAuth 2.0
3

Link an Account

Connect an account using StackOne Hub or Auth Link.
https://stackone-logos.com/api/microsoft-excel/filled/png

Link Account

Microsoft Excel - OAuth 2.0
4

Use Actions

Invoke actions using one of the methods below: