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