Read All Rows
Read all rows in a worksheet.
A maximum of 500,000 rows can be read.
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 |
Dropdown | TRUE |
| Workbook ID |
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. |
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 |
|---|---|---|---|
| Number of Rows to Skip | Number of rows that should be skipped before start reading the rows. | Number | FALSE |
Output
| Field | Definition | Type |
|---|---|---|
| Rows | Dynamically generated rows object based on the worksheet. | List of Objects |