iRobo.Activity.Set Border

Sets border for a specific range of cells in an Excel Sheet.

                       

     Note: 

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

         Set Border is one of the Excel activities that requires Excel Scope Activity.

                                                                       

Properties

Excel

  • Cell Range - Specify cells range to be read, such as: "A2 : B2". (Mandatory)
  • SheetName -  Excel Sheet name of current Workbook. Default value: "Sheet1".


Input

  • Presets - Specify cell border style. 


Input-Option

  • Delay - Enter execution time in seconds. 


Misc                                                                                                        

  • DisplayName -  Activity header name.


Option

  • Border Color - Set border font color using System.Drawing.Color.*ColorName*.
  • Border Weight - Specify border weight.
  • Line Style - Select border line style.


Output 

  • Output -  Return Boolean indicating characters in cell within specified range. 


Steps of Using Set Border

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Set Border Activity into Excel Scope Activity Body.
  3. Enter Cell Range, such as: "A2 : B2" in Property Panel.
  4. Specify border style in Presets 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: Easily create HTML Help documents