iRobo.Activity.Find
Finds Text within an Excel Sheet and return cell info and row index as an array.
Note: Before using Office Activities, check Office Automation prerequisites from Office Page. Find is one of the Excel activities that requires Excel Scope Activity. |
Properties
Excel
- SheetName - Excel Sheet name of current Workbook. Default value: "Sheet1".
Input
- Cell Range - Specify cell range to be read, such as: "A2 : B2". (Mandatory)
- Find Option - Select find option to look for Text; to find Part of it or Whole.
- Find Text - Specify Text to find. (Mandatory)
- Match Case - Specify to match Text found or not.
Input-Option
- Delay - Enter execution time in seconds.
Misc
- DisplayName - Activity header name.
Output
- Output - Output value as String array of Cell info. (Mandatory)
- Row Indexes - Output value as Integer array of Row indexes. (Mandatory)
Steps of Using Find
- Open iRobo Studio, and then open a new Workflow.
- Drag Find Activity into Excel Scope Activity Body.
- Enter Cell Range to look for Text, such as: "A2 : B2" in Property Panel.
- Specify Text to find in Find Text field in Property Panel.
- Set String Array Variable for Output of the cell info in Property Panel.
- Click Save button from iRobo Studio Menu to save Workflow.
- Click Play button to start the automated process.
Created with the Personal Edition of HelpNDoc: Qt Help documentation made easy