iRobo.Activity.Insert Hyperlink

Adds a hyperlink to a specific cell in an Excel file.


     Note: 

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

         Insert Hyperlink is one of the Excel activities that requires Excel Scope Activity.

                                                                                                               

Properties

Excel

  • SheetName -  Excel Sheet name of current Workbook. Default value: "Sheet1".


Input

  • Address -  Enter String value of hyperlink address. (Mandatory)
  • Cell - Enter cell position as: "A1". (Mandatory)
  • Display Text -  Enter overwritten Text for hyperlink address. (Mandatory)
  • Display Text Overwrite -  Use overwritten Text or not. Its input is True/False arguments. (Mandatory)


Input-Option

  • Delay - Enter execution time in seconds. 


Misc                                                                                                        

  • DisplayName -  Activity header name.



Steps of Using Insert Hyperlink

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Insert Hyperlink Activity into Excel Scope Activity Body.
  3. Enter cell position number in Cell field in Property Panel.
  4. Enter hyperlink address to add in Address 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: Create iPhone web-based documentation