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.