iRobo.Activity.Cell Font
Changes Font Name, Size, Style, Underline, Font Color, Effects of a specific range of cells inside a worksheet in an Excel File.
Note: Before using Office Activities, check Office Automation prerequisites from Office Page. Cell Font is one of the Excel activities that requires Excel Scope Activity. |
Properties
Excel
- Cell Range - Specify cells range to read, as: "A2 : B2". (Mandatory)
- SheetName - Excel Sheet name of current Workbook. Default value: "Sheet1".
Font - Name
- Font Name - Enter cell font name, for example: "Ariel".
- Font Size - Enter cell font size.
- Font Style - Select cell font style.
Font - Effect
- Font Script - Select cell font scripting style.
- Strike Through - Set to strike line through Text or not. Its input is True/False arguments.
Font - Option
- Font Color - Set font color using System.Drawing.Color.*ColorName*.
- Font UnderLine - Select style of underline cell.
Input-Option
- Delay - Enter execution time in seconds.
Misc
- DisplayName - Activity header name.
Steps of Using Cell Font
- Open iRobo Studio, and then open a new Workflow.
- Drag Cell Font Activity into Excel Scope Activity Body.
- Enter Cell Range, as: "A2 : B2" in Property Panel.
- Set Font style, Effect and Option 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: Free Kindle producer