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

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Cell Font Activity into Excel Scope Activity Body.
  3. Enter Cell Range, as: "A2 : B2" in Property Panel.
  4. Set Font style, Effect and Option 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: Free Kindle producer