iRobo.Activity.Merge Cells

Merge specified cells in an Excel file.

       

     Note: 

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

                               

                                               

Properties

Input

  • FileName -  Excel file path including name and extension. (Mandatory)
  • First Cell - Enter the cell position as "A1", to specify the first cell in the range. (Mandatory)
  • Last Cell - Enter the cell position as "C1", to specify the last cell in the range. (Mandatory)

Misc                                                                                                        

  • DisplayName -  Activity header name.


Steps of Using Merge Cells Activity

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Merge Cells Activity to the Sequence.
  3. Enter Excel file path including name and extension in Filename in Input in the Property Panel. 
  4. Enter the First Cell and Last Cell position in Input in the Property Panel.
  5. Click Save button from iRobo Studio Menu to save Workflow.
  6. Click Play button to start the automated process, specified cells in the specified Excel file are merged.

Created with the Personal Edition of HelpNDoc: Free Web Help generator