Read a row of values from an Excel Online worksheet.
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
Option to specify a Excel Online workbook by ID.
Example of a workbook ID:
To get the ID for an Excel Online workbook, see Get a DriveItem resource.
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.
|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|
In the field selection window, select the column letters from which you want to retrieve 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|