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

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Find Activity into Excel Scope Activity Body.
  3. Enter Cell Range to look for Text, such as: "A2 : B2" in Property Panel.
  4. Specify Text to find in Find Text field in Property Panel.
  5. Set String Array Variable for Output of the cell info in Property Panel.
  6. Click Save button from iRobo Studio Menu to save Workflow.
  7. Click Play button to start the automated process.


Created with the Personal Edition of HelpNDoc: Qt Help documentation made easy