iRobo.Activity.Column Move

Moves a column within a worksheet in an Excel file.

       

     Note: 

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

         Column Move is one of the Excel activities that requires Excel Scope Activity.

                                                                                                       

Properties

Excel

  • SheetName -  Excel Sheet name of current Workbook. Default value: "Sheet1".


Input

  • From ColRange - Specify cell range to read, as: "A2 : B2". (Mandatory)
  • To Range - Enter columns range to move to. (Mandatory)


Input-Option

  • Delay - Enter execution time in seconds. 


Misc                                                                                                        

  • DisplayName -  Activity header name.


Steps of Using Column Move

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Column Move Activity into Excel Scope Activity Body.
  3. Enter range of columns to move in From ColRange field in Property Panel.
  4. Enter range of columns to move columns into in To Range field in 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: News and information about help authoring tools and software