iRobo.Activity.Delete Columns

Deletes range of columns in a Worksheet in an Excel file.


     Note: 

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

         Delete Columns is one of the Excel activities that requires Excel Scope Activity.

       

                                                                                               

Properties

Excel

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


Input

  • Columns Range - Specify columns range to be read, such as: {"A:A","B:D","F:I","AA"}. (Mandatory)


Input-Option

  • Delay - Enter execution time in seconds. 


Misc                                                                                                        

  • DisplayName -  Activity header name.



Steps of Using Delete Columns

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Delete Columns Activity into Excel Scope Activity Body.
  3. Enter Columns Range to be deleted, such as: {"A:A","B:D","F:I","AA"} in Property Panel.
  4. Click Save button from iRobo Studio Menu to save Workflow.
  5. Click Play button to start the automated process.


Created with the Personal Edition of HelpNDoc: Easy EBook and documentation generator