iRobo.Activity.Find & Replace

Finds & replaces a text within a specific cells range in the excel file sheet.        

       

     Note: 

         Before using Office Activities, check Office Automation prerequisites from Office Page.

         Find & Replace is one of the Excel activities scope that requires Excel Scope

                                                                       

Properties

Excel

  • Sheet Name -  Enter the sheet name of the current workbook. Default value: "sheet1"


Input

  • Cell Range - Specifies the cells range to be read. Like "A2 : B2".  (Mandatory)
  • Find Text - Specifies Text you would like to find.  (Mandatory)
  • Replace Text - Specifies Text you would like to replace with.  (Mandatory)


Input-Option

  • Delay - Enter the execution time in seconds. 
  • Find Option - Select the find option to look for the text if to Find Part of it or Whole.
  • Match Case - Specifies to match case of the Text you would like to find or not.


Misc                                                                                                        

  • DisplayName -  Activity header name.


Output 

  • Output -  Return a Boolean indicating characters in the cell within the specified range. 


Steps of Using Find & Replace

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Find & Replace Activity into the Excel Scope Activity Body.
  3. Enter the Cell Range to look for the text in it e.g."A2 : B2" from the Property Panel.
  4. Specify the text you would like to find in Find Text field from the Property Panel.
  5. Enter the text you would like to replace with in Replace Text field from the 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: Create help files for the Qt Help Framework