iRobo.Activity.Read Excel Cell Reads specific cell in an Excel file. |
|
Note: Before using Office Activities, check Office Automation prerequisites from Office Page. |
Input
- Cell - Cell number includes "row name" & column number. (Mandatory)
Misc
- ArgumentType - Select value type to read.
- DisplayName - Activity header name.
- FileName - Excel File path. (Mandatory)
- Result - Output Variable to store result.
- Visible - Visible cell or not. Its input is True/False arguments.
- WorkBook - Get Output WorkBook Variable of Excel file.
- Worksheet - Specify Excel Sheet to read from.
Output
- Formula - Insert a formula to calculate cell value.
- Range - Get Output range of cells.
Steps of Using Read Excel Cell Activity
- Open iRobo Studio, and then open a new Workflow.
- Drag Read Excel Cell Activity to the Sequence.
- Click on button in Activity to select Excel File path to read file from, as shown in the image below.
- Enter Cellfield ("Row name" & column number ) to get the number of cell in the Properties Panel, as shown in the image below .
- Select cell ArgumentType to read. For example: String.
- Set an Output Variable to Formula in Properties Panel, then click Ctrl+K to instantly create the variable.
- Drag MessageBox Activity to the Sequence and set the input Message field to the Output Variable of Formula field.
- Click Save button from iRobo Studio Menu to save Workflow.
- Click Play button to start the automated process.
- Message box appears display the output Formula field in Read Excel Cell Activity.
Created with the Personal Edition of HelpNDoc: Free PDF documentation generator