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
- Open iRobo Studio, and then open a new Workflow.
- Drag Delete Columns Activity into Excel Scope Activity Body.
- Enter Columns Range to be deleted, such as: {"A:A","B:D","F:I","AA"} in Property Panel.
- Click Save button from iRobo Studio Menu to save Workflow.
- Click Play button to start the automated process.
Created with the Personal Edition of HelpNDoc: Easy EBook and documentation generator