Excel Online connector

The online version of Microsoft Excel allows you to share and collaborate on Excel spreadsheets. You can save these files in OneDrive.

Authorize your Excel Online account

When you add an Excel Online card to a flow for the first time, Okta prompts you to create a connection. See Authorization.

Revoke Excel Online access tokens

Access tokens can't be revoked. If you delete an Excel Online connection in Workflows, the access token isn't revoked. See the Microsoft documentation for Configurable Token Lifetimes.

You can revoke a refresh token in several ways. See the Microsoft documentation for Access Tokens.

Excel Online connector event cards

Event

Description

Row Added or Updated

Start the flow when a new row is added or updated to the worksheet.

Updated Cell

Start the flow when data within a cell is updated.

Excel Online connector action cards

Action

Description

Add Row

Add a row of data to the end of a worksheet.

Clear Cells

Clear formats and/or data from the designated cells.

Custom API Action

Make a custom, authenticated HTTP call to the Excel Online API.

Delete Cells

Delete cells from an Excel Online sheet.

Get Cell Value

Get information for a cell.

Read All Rows

Read all rows in a worksheet (maximum of 300).

Read Row

Read a row of data from an Excel Online worksheet.

Read Worksheet Info

Retrieve the properties of an Excel Online worksheet.

Search Rows by Column

Search for a row or rows that match a value in a certain column.

Update Cell

Update a value within a row on Excel Online.

Update Row

Update a row in an Excel Online Worksheet.