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 |