iRobo.Activity.Delete Rows

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


     Note: 

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

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

                                                                                                               

Properties

Excel

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


Input

  • Rows Range - Specify Columns range to be read, such as: {"1:5","8:14"}. (Mandatory)


Input-Option

  • Delay - Enter execution time in seconds. 


Misc                                                                                                        

  • DisplayName -  Activity header name.


Steps of Using Delete Rows

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Delete Rows Activity into Excel Scope Activity Body.
  3. Enter the Rows Range to be deleted, such as:{"1:5","8:14"} 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: Free help authoring tool