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