Read Row

Read a row of values from an Excel Online worksheet.

Options

Field Definition Type Required
Workbook

List of workbooks available in your account. Workbook is another word for your Excel files.

If you select a Workbook from the dropdown, ignore the Workbook ID field.

If you select -- Enter Workbook ID -- from the dropdown, then enter an ID in the Workbook ID field.

Dropdown TRUE
Workbook ID

Option to specify a Excel Online workbook by ID.

Example of a workbook ID: 015PGUOTTY6ZMVGBRB65DLDRED7VJJEJTP

To get the ID for an Excel Online workbook, see Get a DriveItem resource.

String FALSE
Worksheet

List of worksheets available in the specified workbook. A worksheet is an individual spreadsheet within a workbook, displayed as a tab in an Excel file.

Dropdown TRUE

Input

Field Definition Type Required
Row
Row Number Number of the row you want to read; this is the number displayed in Excel to the left of the first column. Number FALSE

Output

In the field selection window, select the column letters from which you want to retrieve values.

Field Definition Type
Values
Column letter (A-ZZ) A letter that identifies the column from which to read the row data. Each of the fields will represent the corresponding cell of the read row. String

Related topics

Excel Online connector

About the elements of Okta Workflows

Excel Online API documentation