iRobo.Activity.Extract HyperLinks

Extracts hyperlinks from a specific cell range within a given an Excel Sheet.

               

     Note: 

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

         Extract Hyperlinks is one of the Excel activities that requires Excel Scope Activity.

                                                                               

Properties

Excel

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


Input

  • Cell Range - Specify cell range to be read, such as: "A2 : B2". (Mandatory)


Input-Option

  • Delay - Enter execution time in seconds. 


Misc                                                                                                        

  • DisplayName -  Activity header name.


Output 

  • Result -  Enter String Array Variable to get all extracted hyperlinks. (Mandatory)


Steps of Using Extract HyperLinks

  1. Open iRobo Studio, and then open a new Workflow.
  2. Drag Extract HyperLinks Activity into Excel Scope Activity Body.
  3. Enter Cell Range , such as:"A2 : B2" in Property Panel to extract hyperlinks from it.
  4. Create String Array Variable and add it to Result field in Property Panel for the extracted hyperlinks.
  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: Easily create HTML Help documents