Actions

Files.Read Files.ReadWrite

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