iRobo.Activity.Change Excel Format

Changes cell format in Excel File. 

     Note: 

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

                                                                                                               

Properties

Input

  • EditPasswod -  Enter Excel File password, to enable editing.
  • FileName - Enter Excel file name,extension and path. (Mandatory)
  • OpenPassword -   Enter Excel File password, to open.
  • Range -  Specify range of cells to read. (Mandatory)

     Note: 

         If this value is not specified, the Robot reads the whole spreadsheet.
  • SheetName -  Excel Sheet name of current Workbook. (Mandatory)


Misc                                                                                                        

  • DisplayName -  Activity header name.


Options

  • AutoFit -  Set cell content position to be auto fit or not. Gets True/False input values.
  • AutoFit -  Set  cell content Font to be Bold or not. Gets True/False input values.
  • AutoFit -  Set cell Format with Border or not. Gets True/False input values.


Style

  • FontColor -  Enter System.Drawing.Color.*ColorName* for the specified cell.
  • FontSize -  Enter cell font size.
  • FontStyle -  Enter cell font style name.



Steps of Using Change Excel Format

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Excel Change Format Activity to the Sequence.
  3. Enter Excel file path including name and extension in FileName field in Property Panel.
  4. Enter cells range to be formatted in Range field in Property Panel.
  5. Enter Excel Sheet name of  current Workbook in SheetName field in Property Panel.
  6. Set cell format to apply in Style Fields in Property Panel.
  7. Click Save button from iRobo Studio Menu to save Workflow.
  8. Click Play button to start the automated process.

Created with the Personal Edition of HelpNDoc: Easy to use tool to create HTML Help files and Help web sites