Read Row

Read a row of data from an Excel Online worksheet.

Options

  • Workbook(dropdown): a list of workbooks available to the account. Workbook is another word for your Excel files.

  • Worksheet(dropdown): a list of worksheets available in the selected workbook. Worksheet is the individual spreadsheet within them, displayed as tabs in Excel files.

Input Fields

  • Row

    • Row Number(number): number of the row you want to read; this is the number displayed in Excel to the left of the first column.

Output Fields

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

  • Values

    • Column letter (A-ZZ)(text): 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.

See Also

Excel Online connector

About the elements of Okta Workflows

Excel Online API documentation