Read Row

Read a row of data from an Excel Online worksheet.

Options

Field Definition Type Required
Workbook A list of workbooks available to the account. Workbook is another word for your Excel files. Dropdown FALSE
Worksheet A list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files. Dropdown FALSE

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