Search Rows by Column
Search for a row or rows that match a value in a certain column of an Excel Online worksheet.
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 |
| Column to Search | Column on which the search will be conducted. | Dropdown | TRUE |
| Result Set | Either the first matching row or all matching rows. | Dropdown | TRUE |
Input
| Field | Definition | Type | Required |
|---|---|---|---|
| Column | |||
| Value | Column value. This is the number displayed in Excel on the top of first row. | String | FALSE |
Output
| Field | Definition | Type |
|---|---|---|
| Result | Matching row or list of rows. | String |
| Row ID | Unique identifier of the row. | Number |