iRobo.Activity.IsMerged Cell

Checks if the provided cell is merged or not within the worksheet.

       

     Note: 

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

         IsMerged Cell 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 - Enter the cell position as "A1". (Mandatory)


Input-Option

  • Delay - Enter the execution time in seconds. 


Misc                                                                                                        

  • DisplayName -  Activity header name.


Output 

  • Result -  Return a Boolean indicating the merging of the cell.


Steps of Using IsMerged Cell Activity

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag IsMerged Cell Activity into the Excel Scope Activity Body.
  3. Enter the Cell position to check if it's merged e.g."A2" from the Property Panel.
  4. Specify Boolean variable and ass it to the Result field from the Property Panel.
  5. Click Save button from iRobo Studio Menu to save Workflow.
  6. Click Play button to start the automated process.

Created with the Personal Edition of HelpNDoc: Full-featured Documentation generator